Wednesday, March 21, 2012

How can i notify multiple operators on job completion

Hi,

I have successfully setup the envm to notify one operator on SQL Job completion using DBMail. How do i specify multiple operators to be notified?.

I tried adding the 2nd mail address to

sysmail_account with a ";" as the seperator

Thanks

Prasad

i figured it out,,, u have to add the 2nd operator address by editing the Email name of the operator under SQL Server Agent>>Operators>

Smile...

No comments:

Post a Comment