SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Job stopped working
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

asp__developer
Posting Yak Master

108 Posts

Posted - 08/05/2013 :  14:03:57  Show Profile  Reply with Quote
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 - 08/05/2013 :  14:10:00  Show Profile  Reply with Quote
I tried sending a test email by database mail option. I get this error message:


Edited by - asp__developer on 08/05/2013 14:10:44
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 08/06/2013 :  00:36:07  Show Profile  Reply with Quote
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

India
639 Posts

Posted - 08/06/2013 :  13:54:08  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000