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

Database Mail Disabled but SQL Server Agent Sends Out Alert Emails Expand / Collapse
Author
Message
Posted Friday, March 22, 2013 1:05 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 12:40 PM
Points: 228, Visits: 546
Since executing sysmail_stop_sp (disabling the Mail queue) - sp_send_dbmail will stop working (as expected) but the sql agent still sends out Alert emails when I RAISERROR with Log

I also disabling the Database Mail XP's in configurations and yet the Agent sends out emails.

Any thoughts?

Thanks
Post #1434487
Posted Tuesday, March 26, 2013 10:46 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 12:40 PM
Points: 228, Visits: 546
any thought guys ?
Post #1435764
Posted Wednesday, March 27, 2013 6:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 6:46 AM
Points: 1,059, Visits: 697
Why dont you can delete the Profile which you are using for Alerts..

Post #1435860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse