 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Setup / July 2008sysmail_start_sp
Microsoft SQL Server 2005 - 9.00.3068.00 (X64) I have a job that's failing with the following error: "[Execute SQL Task] Error: Executing the query "exec usp_MySproc" failed with the following error: "Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. " My question is about the fact that db mail is stopped. How does that happen? I have db mail enabled, using the surface area configuration tool, and mail is properly configured inside of SQL - I know this because I can send a mail message. So how does db mail get stopped? I can assure you that no one is issuing sysmail_stop_sp. Any help is appreciated. Thanks, Andre Did you check the SQL Error Logs? There must be some records in the logs about this issue and I think your best bet to understand the problem would be checking out the SQL Error Logs. And also Database Mail Logs of course, there could be some track there as well. (Right click on the Database Mail in SSMS and click View Database Mail Log)  SignatureEkrem Önsoy Microsoft SQL Server 2005 - 9.00.3068.00 (X64) I have a job that's failing with the following error: "[Execute SQL Task] Error: Executing the query "exec usp_MySproc" failed with the following error: "Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. " My question is about the fact that db mail is stopped. How does that happen? I have db mail enabled, using the surface area configuration tool, and mail is properly configured inside of SQL - I know this because I can send a mail message. So how does db mail get stopped? I can assure you that no one is issuing sysmail_stop_sp. Any help is appreciated. Thanks, Andre I checked the logs and I see a bunch of "DatabaseMail process is started" and then "DatabaseMail process is shutting down". But nothing that indicates an error. Ever since I used sysmail_start_sp DB Mail has stayed up. What concerns me is that I had to even do this after I bounced the box, especially since DB Mail is enabled and configured properly. Andre Hmm, then there must be some process which triggers this problem. As there is no an error message or some more specific clue to go after, I don't know what to say... SignatureEkrem Önsoy I checked the logs and I see a bunch of "DatabaseMail process is started" and then "DatabaseMail process is shutting down". But nothing that indicates an error. Ever since I used sysmail_start_sp DB Mail has stayed up. What concerns me is that I had to even do this after I bounced the box, especially since DB Mail is enabled and configured properly. Andre Also, I'd like to share with you the following link where you can have more information about the function of this sp: http://msdn.microsoft.com/en-us/library/ms173412.aspx SignatureEkrem Önsoy Microsoft SQL Server 2005 - 9.00.3068.00 (X64) I have a job that's failing with the following error: "[Execute SQL Task] Error: Executing the query "exec usp_MySproc" failed with the following error: "Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. " My question is about the fact that db mail is stopped. How does that happen? I have db mail enabled, using the surface area configuration tool, and mail is properly configured inside of SQL - I know this because I can send a mail message. So how does db mail get stopped? I can assure you that no one is issuing sysmail_stop_sp. Any help is appreciated. Thanks, Andre |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.