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

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

hoh (2 posts)
February 21, 2011 07:48 AM
Accepted Answer

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

 

Permalink
erinr (8 posts)
February 22, 2011 07:17 AM
Accepted Answer
adTempus already has a report that will do this. It's the Job Execution Schedule report in the reports section of the Console.
Permalink
hoh (2 posts)
March 1, 2011 12:59 AM
Accepted Answer

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)

 

 

 

Permalink

Replies are disabled for this topic.