January 10, 2009 at 10:02 am
Hi
If any job fails is it possible to alert the message to out mail id
if it is possible plz give the navigation
and procedure
with regards
Am
January 10, 2009 at 10:54 am
For every job, there are various options in the properties. One of these is notifications.
You have to set up an operator, set up Database Mail, and then you can select which operator to notify if a job fails.
January 10, 2009 at 10:56 am
First you need to enable and set up database mail (look it up in BOL) and then you need to enable the mail profile for SQL Server Agent. Under the Alert System in SQL Server Agent Properties. You can look this up in BOL as well. Then on the job you need to set it up to send a notification when the job fails on the job properties notifications tab.
Edit -> like Steve said you also need an operator which I forgot.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 12, 2009 at 10:07 am
Enable Database Mail
Add Operator
Change Job property to mail/pager/net send to Operator, on Completion/Success/Failure
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply