• Replies 5 replies
  • Subscribers 336 subscribers
  • Views 21 views
  • Users 0 members are here
Related

Auto-notification for hung scheduled reports?

Former Member
Former Member $organization

Hi,

Is there is an automatic way to be notified when a scheduled job is hung? We want to address this situation in a more efficient way and not depend on users reporting a problem.

Any help would be appreciated.

Thanks,

Jeri

 

Parents
  • $organization

    I am pretty sure that SQL Management Studio has options under advanced job properties to send emails out with success or failure notifications.

  • $organization in reply to Christian Mauri

    I just looked at SQL Management Studio and each job has a notifications tab that has email as an option that can be set to deploy if the job fails.

  • Former Member
    Former Member $organization in reply to Christian Mauri
    Great, thank you so much Christian.  I'll alert our IT department.

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christian Mauri
    Sent: Tuesday, June 09, 2009 4:13 PM
    To: Jeri Henderson
    Subject: Re: [Tessitura Technical Forum] Auto-notification for hung scheduled reports?

    I just looked at SQL Management Studio and each job has a notifications tab that has email as an option that can be set to deploy if the job fails.

    From: Christian Mauri <bounce-christianmauri9105@tessituranetwork.com>
    Sent: 6/9/2009 3:08:26 PM

    I am pretty sure that SQL Management Studio has options under advanced job properties to send emails out with success or failure notifications.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • $organization in reply to Former Member

    Jeri,

    I think I misread your question. Looks like you are referring to the scheduled reports as opposed to a scheduled SQL server job. I gave you instructions on how to send notifications when a SQL server job fails, rather than a scheduled Tessitura report.

    I do not know how to send notifications out when the reports are not deployed. This happens to us too and I get lots of emails like, "Where is the daily report?"

    Sorry for the confusion,

    Christian

  • Former Member
    Former Member $organization in reply to Christian Mauri
    Hi Christian,
    I really appreciate it-thank you very much.

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christian Mauri
    Sent: Tuesday, June 09, 2009 4:33 PM
    To: Jeri Henderson
    Subject: Re: [Tessitura Technical Forum] RE: Auto-notification for hung scheduled reports?

    Jeri,

    I think I misread your question. Looks like you are referring to the scheduled reports as opposed to a scheduled SQL server job. I gave you instructions on how to send notifications when a SQL server job fails, rather than a scheduled Tessitura report.

    I do not know how to send notifications out when the reports are not deployed. This happens to us too and I get lots of emails like, "Where is the daily report?"

    Sorry for the confusion,

    Christian

    From: Jeri Henderson <bounce-jerihenderson2389@tessituranetwork.com>
    Sent: 6/9/2009 3:21:09 PM

    Great, thank you so much Christian.  I'll alert our IT department.

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christian Mauri
    Sent: Tuesday, June 09, 2009 4:13 PM
    To: Jeri Henderson
    Subject: Re: [Tessitura Technical Forum] Auto-notification for hung scheduled reports?

    I just looked at SQL Management Studio and each job has a notifications tab that has email as an option that can be set to deploy if the job fails.

    From: Christian Mauri <bounce-christianmauri9105@tessituranetwork.com>
    Sent: 6/9/2009 3:08:26 PM

    I am pretty sure that SQL Management Studio has options under advanced job properties to send emails out with success or failure notifications.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • Former Member
    Former Member $organization in reply to Christian Mauri
    Hi Christian,
    I really appreciate it-thank you very much.

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christian Mauri
    Sent: Tuesday, June 09, 2009 4:33 PM
    To: Jeri Henderson
    Subject: Re: [Tessitura Technical Forum] RE: Auto-notification for hung scheduled reports?

    Jeri,

    I think I misread your question. Looks like you are referring to the scheduled reports as opposed to a scheduled SQL server job. I gave you instructions on how to send notifications when a SQL server job fails, rather than a scheduled Tessitura report.

    I do not know how to send notifications out when the reports are not deployed. This happens to us too and I get lots of emails like, "Where is the daily report?"

    Sorry for the confusion,

    Christian

    From: Jeri Henderson <bounce-jerihenderson2389@tessituranetwork.com>
    Sent: 6/9/2009 3:21:09 PM

    Great, thank you so much Christian.  I'll alert our IT department.

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christian Mauri
    Sent: Tuesday, June 09, 2009 4:13 PM
    To: Jeri Henderson
    Subject: Re: [Tessitura Technical Forum] Auto-notification for hung scheduled reports?

    I just looked at SQL Management Studio and each job has a notifications tab that has email as an option that can be set to deploy if the job fails.

    From: Christian Mauri <bounce-christianmauri9105@tessituranetwork.com>
    Sent: 6/9/2009 3:08:26 PM

    I am pretty sure that SQL Management Studio has options under advanced job properties to send emails out with success or failure notifications.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
No Data