status_table

Hi All,

I have a Job_status_table which will keep track of the status of the cron jobs.I built one procedure where in, it logs on the start-time, end_time, job_name,status_flag of all the cron jobs when executing.When the script(job) fails, it will not put the end_time and marks the status_flag as 'N'.

Now I would like to create a procedure that checks our job_status table to look for any abended or hung jobs ( we'll need to make sure to make allowances for active jobs so probably just look for records with an hour or so ago start time/date but no end time/date). Once we have a procedure like this we can call we can schedule it in cron to run every 5 minutes or so.

Help is appreciated,
Thanks,
Choti Received on Wed May 31 2006 - 17:01:26 CDT