locked
SQL Notification - Looking to be notified when a process Hangs RRS feed

  • Question

  • I must first start out by saying I have no programming experience and so far I have been navigating SQL solely via the SSMS. From time to time my scheduled jobs become hung-up. My notifications are set to notify me when the job fails. I am looking for a way to be notified when the job is stuck in a continuous loop. I could modify the notification to email me when the job is successful, but I have multiple servers and jobs that run through out the week and would prefer not to get inundated with notifications.

    Thanks for any help you can provide.

    Thursday, June 9, 2011 12:17 AM

Answers

  • Hi,

    >>I am looking for a way to be notified when the job is stuck in a continuous loop.

    You may set the "Retry attempts" of the job step to a low value such as 0, 1 so that you will get notified once job fails. Please let me know if I misunderstood you.


    Best Regards | Alex Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, June 14, 2011 7:44 AM