Post reply

Multiple Operator Notifications and Data Base Status

  • November 14, 2007 at 5:19 pm

    #179340

    Hi everyone. Is it possible to notify more than one operator of the same job completion? The notifications of Job Properties drop down permits only one e-mail recipient per job.

    Also, my supervisor wants a daily report of the health of our databases. Nothing elaborate, just a go no-go type of report generated from within the SQL engine. Any suggestions?

    Thanks for everyone for being there to help.

    2005 SQL Standard.

  • November 15, 2007 at 3:29 am

    #751420

    create a group in exchange - add the group as the recipient

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • November 16, 2007 at 10:00 am

    #751901

    Hello,

    In case you haven't gotten a solution to this, you can configure and use the 'sqlmaint' utility as a nightly job. You can get more information on this from the SQL server books online.

    Good luck.

    Ooko.

  • November 16, 2007 at 10:53 am

    #751924

    Thanks. I'll pass this by our Exchange manager

  • November 16, 2007 at 10:55 am

    #751926

    Thanks John for the utility tip.

  • November 18, 2007 at 11:00 am

    #752105

    Ed Wyant (11/14/2007)

    Hi everyone. Is it possible to notify more than one operator of the same job completion? The notifications of Job Properties drop down permits only one e-mail recipient per job.

    Yes, that seems like a shortcoming not to be able to put multiple accounts in the job notification. You can put multiple addresses in the operator definition. I've created several different operators, and then put the appropriate one into the job notification. For critical jobs, my "DBA_Notification" operator has my work email, personal email and cell phone.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply