Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lenovo27
Starting Member
15 Posts |
 Posted - 2010-06-15 : 11:26:00
|
| The dba before me had the jobs set up with his domain account as the owner. He left the department but still works in the organization. Up until today, the server agent jobs for backups worked fine.So I went into SQL Server Agent Jobs and changed the domain account that these jobs run under to an admin account. I can manually start each job and execute them successfully, but they are scheduled jobs and their schedules are not executing.For example: I can manually start a transaction log backup job and have it complete successfully, but the job is scheduled to occur every 30 minutes and it is not occurring every 30 minutes. The only way I can get it to execute is manually.Background: SQL Server 2008 Enterprise. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-06-15 : 11:40:35
|
| Check the owner on each job, in all likelihood it's the original DBA's account. Change the job owner to sa and see if that fixes it. |
 |
|
|
|
|
|
SQL Server Agent Jobs stopped executing