sql server agent job with SSIS

Question

Hello Experts

i have a sql server agent job that has four steps in tsql,ssis,tsql and tsql orders. the job run automatically every night and i copy paste the error message right here, any ideas please:

Date                      1/27/2014 7:30:00 AM

Log                         Job History (test [Mon-Fri AM])

Step ID                 1

Server                   server1

Job Name                            name [Mon-Fri AM]

Step Name                         step one

Duration                              00:34:33

Sql Severity                        0

Sql Message ID                 0

Operator Emailed                           

Operator Net sent                          

Operator Paged                               

Retries Attempted                          0

Message

Executed as user x\serveragent. The step was cancelled (stopped) as the result of a stop job request.

Answer 1

The error clearly suggest someone (or may be process) invoked explicit stop job request to stop the job. It may be by calling sp_stop_job system sp or by manually stopping it from sql agent. In your case its the former as time is outside business hours and also account used was sql agent service account.

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

Answer 2

In addition to Visakh16 answer, check if you have any other job enabled at that hour (right click on "Jobs" folder>"View History"), or if this is a virtual machine, check if there is an external backup that needs to shut down or pause the machine.

---

Please, mark this post as Answer if this helps you to solve your question/problem.
Alan Koo | "Microsoft Business Intelligence and more..." http://www.alankoo.com

Answer 3

I am moving it to tools.

---

Kalman Toth Database & OLAP Architect SELECT Video Tutorials 4 Hours
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012

Answer 4

you can try default trace / event viewer to check if there is any entry on same .

How to read default trace in sql server

---

Thanks Saurabh Sinha

http://saurabhsinhainblogs.blogspot.in/

Please click the Mark as answer button and vote as helpful if this reply solves your problem