SQL job failure e-mail notification

  • Hi

    I wish to be notified by email when my sql job fails.

    However all our jobs are scripted on development servers before being put live so need to have the correct email address on the development job.

    We often refresh all out devt. servers (20+) from live so I want to avoid having to go through and disable each job on each server after every refresh.

    Is there a way to globally disable the email notifications on a server basis?

    we can't really afford to have test/devt. data being emailed out to live addresses!

    thank you for your time..

  • if youre using databasemail you can just disable it

    http://msdn.microsoft.com/en-us/library/ms191189.aspx

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

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