May 23, 2003 at 4:54 pm
I have a scheduled package that hits a web page via xmlhttp. Every couple of days (randomly) the job hangs. The log provides no clues. The worst part is that since the job hangs, SQL does not consider it to be a success or a failure and the only way I find out about it is by a client calling me and asking why that functionality doesn't work. Is there some way to get the job to notify me "on-hang?"
May 23, 2003 at 5:38 pm
Hello. Take a look at sysjobhistory in the msdb database. I've never used it but between run_date, run_status & run_duration you can probably put something together (ex: run job at 8:00AM that looks for hanging jobs).
Another idea: If you have a lot of jobs, how about writing success/failure to one table or place every day. That way you can check one place for failures or unrecorded jobs.
Everett Wilson
ewilson10@yahoo.com
June 6, 2003 at 3:13 pm
Thanks a ton! That got me to a point to where I could build a job that emails me if the job hangs. However, is there a way to stop the scheduled package from an SP? That way, ihstead of emailing me, it resets the schedule.
Thanks again for the original help!
June 6, 2003 at 3:36 pm
Hello. You can use sp_update_jobschedule (@enabled property) to enable or disable a job.
Everett Wilson
ewilson10@yahoo.com
June 6, 2003 at 4:06 pm
Outstanding!!! Thank you so much!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply