[SCCD] Finding Parameter Value of Report Schedule

Some report have parameter to filter the result records. But when these reports have been set as schedule we can not see it in the system. However, we can see these value for each parameter in the database.

Firstly you can query data in REPORTSCHED table. You will see report schedule information. Then notice the CRONTASKNAME and INSTANCENAME.

These 2 values are also in CRONTASKPARAM table. So you can see parameter value in this table by using where CRONTASKNAME and INSTANCENAME.

 

...
Social tagging: > > >

Leave a Reply