scheduled job.

Question

Hi,

I have scheduled a job,due to some network problem job get stopped I saw error message on next day...now what are the steps to be followed.

 

Regards,

Er.Karthikn

Answer 1

Hi,

Go to your step and see what is the problem, sometimes it be login and others bad synatx. see the error and then change the required change on your step.

http://www.databasejournal.com/features/mssql/article.php/3285691/Troubleshooting-SQL-Server-Jobs.htm

 

I hope this is helpful.

 

Elmozamil Elamir

MyBlog

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
http://elmozamil.blogspot.com

Answer 2

Hi Er.karthikn,

Could you give more detail? Please post the error message and error log for further troubleshooting.

---

Regards, Amber zhang

Answer 3

You have to check job history as first stop: right click on job in SSMS Object Explorer --> View History .

In addition you may have to check other error logs as well as Event Viewer.

Programmatic control of jobs article:

http://www.sqlusa.com/bestpractices2005/startjobfromstoredproc/

Since network interruption happened, ideally the job can be just restarted and will finish.  The assumption is that the job has been designed to be rerunnable in case of network interruption. Restartability is a very important & desirable feature of production jobs. You don't want to do diagnostics and "repair" each time something happens. You just want to restart so it finishes.

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012