April 1, 2009 at 4:41 pm
Hi Guys,
I have several Jobs running with different schedule. For example one sql job runs every 15 mins. As we are busy with our daily jobs sometime with any means this job gets disabled it will not be running and we are unaware of the fact that the job is disabled. So, it has been couple of times that we got the job is not running after 2 days. So, to alert us with this fact that the job is disabled we want to automate a process to have a check job job that will basically check whether or not the job is running or not. How can I do this ? I may not require that it should tell me that at the regular 15 min it is not running but I may want that if the job is not running for an hour or two than it provides me an alert so that somebody or me can go and check the server and see whats going on.. If it is disabled than enable or find the reason of why it is disabled and so on...
Can you guys help me with this?? Will appreciate it..
Thanks.
April 1, 2009 at 5:10 pm
Double post. Please do not cross-post. Please direct all replies to this thread: http://www.sqlservercentral.com/Forums/Topic688473-149-1.aspx
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply