CODEWITHSUNDEEP
sqlsql-server-2008-r2jobs
Raja
Raja

Reputation: 1

Jobs are not running on schedule

I have a job scheduled to run daily at 10 PM. It was running fine but now, it is not. It stopped running on schedule and I need to manually kickoff the job daily.

Jobs are scheduled to run with [sa] account and password has not expired.

I don't understand why this is happening suddenly.

My server is SQL Server 2008 R2. Even I restarted the server couple of days back. Do I need to install any service pack/hotfix?

Upvotes: 0

Views: 386

Answers (1)

anm
anm

Reputation: 1927

I ran into the same issue, make sure there isn't another job running before that may delay the start off of the job and make sure the algorithm is fcfs. To debug, set the job to run at a different time, and if it runs successfully there may be another job slightly earlier then 10 causing the error.

Upvotes: 1

Related Questions