how to get multiple operators in job notification

Question

how to get multiple operators in job notification

MAK-1128556

SSCarpal Tunnel

Points: 4594
More actions
September 14, 2009 at 3:04 pm

#385359

Failures, success, or completions? The present database mail configuration works great for a single operator to receive a single job status… success or fail or complete. However, if I want to assign
multiple operators of the same job’s status, the operator window drop down menu of the job properties dialog box limits me to assign one operator at a time. Thanks to everyone for being there to help.
SQL 05 SP3

Viewing 5 posts - 1 through 4 (of 4 total)

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

JeremyE SSCoach Points: 16199 More actions · Answer 1

You can add multiple email addresses to an operator by separating the addresses with a semicolon. Also, you could create an active directory distribution group with all the users and add the distribution group's email address to the operator.

Anam Verma SSCertifiable Points: 5365 More actions · Answer 2

I'll recommend the same as of Edogg to create an active directory distribution group with all the users and add the distribution group's email address to the operator. It is easy to maintain like adding and removing users from active directory group. Also you can use the same group email address in multiple jobs otherwise you have to modify every job when you have to add or delete an email address.

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 3

Thanks for the replay, i already have a group and every one receving an email, but my question is how to send a auto email when job is start, when job is failed or when job is successed

Greg Charles SSC-Forever Points: 45403 More actions · Answer 4

Since you can only use built-in notification for one of those, I would put EXEC xp_sendmail in a couple of job steps for the other two situations. For example, to notify the operators that the job has started (which I, personally, think is unnecessary), make the first step send an email with that information in @subject and/or @message.

Incidentally, it seemed pretty clear, given the title and content of your original post, that you were asking how to send job notification to multiple operators, so it's no surprise the first two replies answered that question.

Greg