Some SQL Server Agent Jobs will not run after restore.
Posted on 2010-11-22
Recently we had a data drive containing our SQL databases fail and had to restore from backups. Everything is up and running fine except this problem with scheduled jobs.
We have some jobs scheduled to backup and perform maintenance on the databases. Those jobs run fine as scheduled.
However we have some DTS packages that are scheduled but will not run since the restore. I can run the packages maunally and they work fine, they just wont run as scheduled. When I try to start the scheduled job from within the management console they hang. I've tried stopping and startng the SQL Server Agent but that hasn't helped.
Thank you for your suggestions.