Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SQL Notification - Looking to be notified when a process Hangs

已答复 SQL Notification - Looking to be notified when a process Hangs

  • Thursday, June 09, 2011 12:17 AM
     
     
    Sign In to Vote
    0

    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.

     

All Replies

  • Tuesday, June 14, 2011 7:44 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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.