Thanks VR,
I've dropped the code tags and italicized the SQL query :-)
From the Tidal client, goto Job Activity, and click on the printer icon, then you have the option to save as a qrp (quick report) file or txt (text) file.
From the database backend, you can run a simple Select query:
SELECT jobmst.jobmst_name, jobrun.* FROM jobrun
JOIN jobmst ON jobmst.jobmst_id = jobrun.jobmst_id
WHERE jobrun_proddt >= '10/27/2015' AND jobrun_proddt < '10/28/2015'
AND jobrun.jobrun_adhoc = 'N'
ORDER BY jobrun.jobrun_esttime,jobrun.jobrun_time
The results returned from the above query will return all jobs scheduled for 10/27/2015, but does NOT include adhoc / inserted jobs. If you wish to include all scheduled jobs and adhoc jobs, then you can remove the last where clause.
BR,
Derrick Au
