I have a scheduled job which runs a group of stored procedures and T-sqls scheduled every morning. It has been kept running for over a year and it usually take about two and half hours to run. Yesterday a weird problem happened. Job status shows job run successfully but actually the job hasn't completed. Somehow it stopped running in the middle of the stored procedures. I don't know where should I look to diagnose the issue. Any help is appreciated. Thanks.


Re: Weird Problem with Scheduled Job

Diane Sithoo

Check the SQL Server Error Logs, as well as the Windows Event Logs relating to your troubles. I had something similar happen before, resulting from bad code which ran and swelled-up msdb. Ensure that your databases are fine and that you don't have any disk space or hardware issues.