Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 dmail where is @recipients file

Author  Topic 

sox
Starting Member

1 Post

Posted - 2012-10-23 : 20:56:29
Hi,

I just started with a company and has been given a SQL server database to maintain. One thing that was set up in this database was a report which was generated and sent out everyday. This report is located in the SQL server agent under Jobs. I need to add some people to the mailing list. After some research, I found the mailing list under the following :

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Exception Reports',
@recipients = 'med@cstltl.com',

However, I cannot find where the med@cstltl.com list is located. Can some one tell me where this file would be located and/or how to edit. I appreciate any help

Thank You

Alan

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-23 : 21:31:31
looks like a Activity Directory group to me.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2012-10-24 : 02:49:45
You should ask the people managing your mail server to add/remove some people from this group. What you have is an active directory group (or whatever directory server is being used) that has an email address assigned to it so all mail that is sent to this address is passed on to all the members in the group.

- Lumbago
My blog-> http://thefirstsql.com
Go to Top of Page
   

- Advertisement -