SQL SERVER AGENT JOBS FAILED

Question

WHEN I START MY JOB

IT FAILES AT FIRST STEP SAYING "START FAILED FOR JOB "NEW"(Microsoft.SqlServer.smo)

no other error message. and if i see reports there is no report also.

any idea?

Answer 1

Does your job execute an SSIS package and which version of SQL Server are you using?

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

If you right-click on the Job you can select "View History".  Once the history is displayed look on the Left of the white cross with red background and you will see a +, click that to expand the history of your attempt to run the Job and click on the failed step; the history is then displayed at the bottom of the window.

---

Please click "Mark As Answer" if my post helped. Tony C.

Answer 3

yes my job run ssis package, which is developed sql server data tools.

in the history also i see same message 

Answer 4

Hi coool_sweet,

Based on my research, the issue always occurs when the SQL Server Agent Service not start, it might be in Starting mode.

So please confirm SQL Server Agent Service is running from the Start menu in Windows, go to SQL Server 2012, Configuration Tools, SQL Server Configuration Manager. Besides, there should be some additional information for the job failure, like “SQLServerAgent is not currently running so it cannot be notified of this action.”

The following similar thread is for your references:
https://social.technet.microsoft.com/Forums/office/en-US/047156e0-3e72-49f7-bf9f-12bd9308ccb5/problem-running-jobs?forum=sqltools
https://social.technet.microsoft.com/Forums/sqlserver/en-US/1f8d7475-593c-4639-8b99-7f5be34ce24b/unable-to-execute-maintenance-plan?forum=sqlgetstarted
https://social.technet.microsoft.com/Forums/exchange/en-US/c3d9df60-f55c-4b16-9631-30fb0482270e/job-failure?forum=sqlgetstarted

Thanks,
Katherine Xiong

---

Katherine Xiong
TechNet Community Support