Find the Starttime of the Job when they are executing

vinay249 · New User Joined: 18 Apr 2007 Posts: 13 Location: Bangalore

Hi,

I have a requirement to find the starttime of the jobs when they are executing because few jobs are taking longer time than useful and holding the database and more than 20 executes at the same time. It takes time to check each and every job start time.

For example.

If A, B, C and D are executing, I need the time of the jobs when they started exectuion.

Thanks!!

enrico-sorichetti · Posted: Sun Nov 30, 2008 5:27 pm

Your request is a bit generic...
look at the console log (LOG) , sdsf status (ST) , Your scheduler facilities...

nothing more to tell until You clarify the process

ofer71 · Posted: Sun Nov 30, 2008 5:46 pm

A REXX with SDSF commands might be your answer. You can also run this REXX as a started task.

O.

expat · Posted: Sun Nov 30, 2008 8:18 pm

SMF records are the easiest and most accurate source of information

dick scherrer · Posted: Sun Nov 30, 2008 10:39 pm

Hello vinay,

Are you looking at jobs that are currently running or have the jobs run sometime in the past (hour, day, week)?

Looking in the spool (sdsf) may be quite hit-or-miss as the jobs in the spool are not constant. As Expat mentioned, SMF records have everything you need.

If you are trying to diagnose something in "real-time" then using sdsf will give you quick access to jobs still running.

diwa_thilak · Posted: Wed Dec 03, 2008 12:18 am

Hello Vinay,

I believe every project will have a scheduler, you can check with your project team for the scheduler.

If you browse through the scheduler you can filter the job as per your request and you can see the Job run stats.

If you have access to the reports (INFOPAC), i believe production control will generate reports (Job run stats) and long running job details in a report. You can even use these reports for your analysis.