Project and Portfolio Management Practitioners Forum
cancel

Need to automate a report.

Highlighted
Vivek Rokade
New Member.

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
Acclaimed Contributor.

Re: Need to automate a report.

Vivek,

Is there a reason you are not just scheduling this from the front end?
Vivek Rokade
New Member.

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.