24. ledna 2012 5:12
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.
24. ledna 2012 5:51
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.
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
- Navržen jako odpověď Papy NormandModerator 10. dubna 2012 21:17
26. ledna 2012 2:55ModerátorHi Er.karthikn,
Could you give more detail? Please post the error message and error log for further troubleshooting.
Regards, Amber zhang
30. března 2012 15:32
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:
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.