Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Need to automate a report.

Highlighted
Vivek Rokade
Acclaimed Contributor

Need to automate a report.

Hello,

I need to automate a report that is supposed to be run everyday. Any thoughts on how do I proceed with it?

I can schedule the report from the application, but not by inserting a row in the below table.

I've tried to insert the relevant details in the KNTA_REPORT_SUBMISSIONS table with status_code = 'SCHEDULED' but it won't run.

2 REPLIES
Jason Nichols K
Honored Contributor

Re: Need to automate a report.

Vivek,

Is there a reason you are not just scheduling this from the front end?
Vivek Rokade
Acclaimed Contributor

Re: Need to automate a report.

These reports have to be run daily. There are a total four such reports which will be run in a sequence. The first report of the series is dependent on a event in the database. This event can be polled by a small code. If this event comes out to be true.... I then need to schedule the reports in sequence.
//Add this to "OnDomLoad" event