How to create a calendar report on scheduled jobs that will show scheduled jobs that were run

Joshua Comeau
Kilo Sage

Configuration I have so far:

JoshuaComeau_0-1707249721710.png

 

JoshuaComeau_1-1707249743909.png

currently my only options to play with is the following 

but what is happening is its only reporting on the actual starting field 

and I want to be able to make the calendar show pending/scheduled jobs that will run lets say tomorrow not just that its starting on this date..

EX:

JoshuaComeau_2-1707249851449.png


is it something in here that would meet the request:

JoshuaComeau_3-1707249922216.png

 

 

 

2 REPLIES 2

siva krishna M2
Tera Guru

Hello @Joshua Comeau ,

 

I would suggest you to create report on sys_trigger and apply filter to get scheduled execution of report records and use next run to know when the scheduled reports will run

 

If it helps, kindly click on like icon and mark it as accepted solution

 

@siva krishna M2 can you send configuration of how you are doing that I do not even see the option to select that table in report view