Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Database Mail extra profile Expand / Collapse
Author
Message
Posted Tuesday, October 16, 2012 1:49 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 5, 2014 12:19 PM
Points: 66, Visits: 596
I just installed database mail on SQL Server 2008 Enterprise Edition. While doing the install I couldn't help but notice another profile. After I completed my install, I went to the SQL Server Agent properties ==> Alert System. There were two things I noted,
one the "Enable Mail Profile" was not checked. The other was after checking it the Mail profile dropdown list yielded another profile which apparently never went live.

I'm tempted to delete the profile but the cautious soul that I am - wanted to know if there were scripts that could use it without the Enable Mail Profile? And is there any way to search for it? This is a cluster environment so reviewing job by job would be a
handful.

Any comments / suggestions would be appreciated.
Post #1373507
Posted Monday, October 29, 2012 3:53 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 3:47 PM
Points: 3,087, Visits: 1,437
jralston88 (10/16/2012)
I just installed database mail on SQL Server 2008 Enterprise Edition. While doing the install I couldn't help but notice another profile. After I completed my install, I went to the SQL Server Agent properties ==> Alert System. There were two things I noted,
one the "Enable Mail Profile" was not checked. The other was after checking it the Mail profile dropdown list yielded another profile which apparently never went live.

I'm tempted to delete the profile but the cautious soul that I am - wanted to know if there were scripts that could use it without the Enable Mail Profile? And is there any way to search for it? This is a cluster environment so reviewing job by job would be a
handful.

Any comments / suggestions would be appreciated.
Check these links:
- http://msdn.microsoft.com/en-us/library/ms175887(v=sql.90).aspx
- http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/





My blog
Post #1378494
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse