December 14, 2011 at 2:53 pm
Hi People,
I have created group call SQL notification in Active directory add with 3 users in that group.
I want to notify that group when the SQL agent job completes .
how i can set up using sql agent notification ? or how i can set notification to SQL notification group by any otherway ? any scripts?
Thanks
December 14, 2011 at 3:48 pm
My AD admins set up a distribution list with my DBA group as members. I created an operator with the distribution list's email address then added that operator to the job notification.
How to: Create an Operator (SQL Server Management Studio)
Use the 'Notifications' page of the Job to send the email based on some action. Job Properties / New Job (Notifications Page)
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
December 14, 2011 at 4:01 pm
Hi ,
So there is one operator for your DBA distribution list am i right?
December 14, 2011 at 5:00 pm
Yeah, one operator that was created using the distribution list email. The job completes, sends to that operator (which is defined as our distribution list email) and all three of us get the completion notice.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
December 15, 2011 at 7:11 am
perfect thanks for your information.I will try that way and let you know how it works.
Have a good day
December 15, 2011 at 7:32 am
Another option is available if you have sufficient information stored in AD anyway: Qyery Based Distribution group. This group does not have any members, but enumerate those matching the LDAP query at the time it receives a mail. In this way, you can for instance send mail to all users who have "SQL" in the description field (just as an example). The drawback? Extra load on the domain controllers when it executes the LDAP query.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply