scheduled job.
-
Tuesday, January 24, 2012 5:12 AM
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
All Replies
-
Tuesday, January 24, 2012 5:51 AM
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.
I hope this is helpful.
Elmozamil Elamir
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- Proposed As Answer by Papy NormandModerator Tuesday, April 10, 2012 9:17 PM
-
Thursday, January 26, 2012 2:55 AMModeratorHi Er.karthikn,
Could you give more detail? Please post the error message and error log for further troubleshooting.
Regards, Amber zhang -
Friday, March 30, 2012 3:32 PM
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- Proposed As Answer by Papy NormandModerator Tuesday, April 03, 2012 8:15 PM
- Edited by Kalman TothMicrosoft Community Contributor Saturday, October 06, 2012 5:27 AM
.png)
