	Site Search:
Home Products Products Overview adTempus Report Commander Arcana Scheduler Support Support Home Knowledge Base License Management Contact Support Community Purchase Pricing and Ordering Additional Purchasing Information Contact About Us

Community

SQL query to get job "time" trigger for all jobs, e.g. "run at 04:50 on mo"

You must be logged in to reply to this topic.

(Showing 1 to 3 of 3)

hoh

Joined: February 21, 2011
Posts: 2

Posted February 21, 2011 9:48:04 AM

To get a quick overview over all job executed on a server, I have createt a sql query that list groupname, jobname, executionstarget, runjobdescription. I also want the trigger time shown but i can't find out in witch Table it saved. I have looked in the Toad data modeler .....

erinr

Joined: August 13, 2003
Posts: 8

Posted February 22, 2011 9:17:00 AM

adTempus already has a report that will do this. It's the Job Execution Schedule report in the reports section of the Console.

hoh

Joined: February 21, 2011
Posts: 2

Posted March 1, 2011 2:59:03 AM

I am aware off that, but thanks. I want the information shown together with the other information. Like a short an quitch overview like this:

Groupname jobname executionstarget runjobdescription starttime(trigger)