August 27, 2009 at 9:49 am
Hi
I wanted to know if there was a way to relate an operator for job notification to a database profile instead. Basically I have a large SQL farm environment with serveral dozen jobs relating to different applications and support teams. In SQL 2000, I have a script to check the status of the job in the history table. if the job failed, any email would be sent.
Is there an easier way in 2005 to associate a job failure notification with a particular DBmail profile?
August 28, 2009 at 12:01 am
You can create the various Operators in SQL 2005 and assign the specific job to send mail to related operator when the job fails.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 28, 2009 at 7:33 am
The problem with creating operators in SQL 2005 is that the operators are always tied to the default DB mail profile. I wanted to associate each operator with a particular mail profile.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply