asked
Deleted SQL Server 2008 Database mail continues to send emails notifications.
As a novice on SQL Server 2008 Standard I used the configuration wizard to create a Database Mail account. After deleting the account it continues to send emails. The "View, change, or delete an existing account" options are grayed out. As well as the "View, change, or delete and existing profile...." Where do I go to stop the emails? Point of clarification: I ran the status and it returned Operator's I had configured. My point of clarification is the mail is still going to the email address I configured under "Outgoing mail server SMTP" > E-mail address in configuration wizard. That's what I need to stop
If it is a scheduled job sending out emails you can disable the job. Can you run the following and post back if it has anything useful: --check status of database mail SELECT * FROM msdb.dbo.sysmail_allitems --check error message SELECT * FROM msdb.dbo.sysmail_event_log EDIT: Im not sure whether this applies for 2008 or not but for 2005 [here][1] it says:( >Disabling Database Mail prevents the Database Mail program from starting, but if Database Mail is running when the option is changed, Database Mail continues to run and process mail (without query or attachments) until it completes sending mail [1]:
http://msdn.microsoft.com/en-us/library/ms188022(v=sql.100).aspx
I ran the status and it returned Operator's I had configured. My point of clarification is the mail is still going to the email address I configured under "Outgoing mail server SMTP" > E-mail address in configuration wizard. That's what I need to stop.
Take a look at
http://technet.microsoft.com/en-us/library/ms191189.aspx says "Setting the Database Mail XPs option to 0 prevents Database Mail from starting. If it is running when the option is set to 0, **it continues to run and send mail** until it is idle for the time configured in the DatabaseMailExeMinimumLifeTime option. "
Just had a thought. If I disable this feature will all email functions be disabled for the server?
