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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Job stopped working

Author  Topic 

asp__developer
Posting Yak Master

108 Posts

Posted - 2013-08-05 : 14:03:57
Suddenly my sql job stopped working and I tried creating a new job and I get error:


Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
08/05/2013 13:59:56,MYSQLJOB,Error,0,SERVER11,MYSQLJOB,(Job outcome),,The job failed. The Job was invoked by User DOMAIN\UserA. The last step to run was step 1 (SENDmail).,00:00:00,0,0,,,,0
08/05/2013 13:59:56,MYSQLJOB,Error,1,SERVER11,MYSQLJOB,SENDmail,,Executed as user: NT AUTHORITY\SYSTEM. Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail. [SQLSTATE 42000] (Error 14641). The step failed.,00:00:00,16,14641,,,,0

asp__developer
Posting Yak Master

108 Posts

Posted - 2013-08-05 : 14:10:00
I tried sending a test email by database mail option. I get this error message:

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-06 : 00:36:07
the error message is obvious. You need to start up database mail using the suggested system stored procedure

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2013-08-06 : 13:54:08
USE Master
GO
sp_configure 'show advanced options', 1
GO
reconfigure with override
GO
sp_configure 'Database Mail XPs', 1
GO
reconfigure
GO
sp_configure 'show advanced options', 0
GO

This will startup database mail.

mohammad.javeed.ahmed@gmail.com
Go to Top of Page
   

- Advertisement -