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 |
|
robvolk
Most Valuable Yak
15732 Posts |
 Posted - 2001-07-09 : 12:04:49
|
| I recently changed my sa password. I recreated my scheduled jobs afterward and they do not run at all anymore (they are DTS jobs, the server connections were not affected by the password change). I can run the DTS packages manually. I can also start the jobs manually, but they fail immediately.I have changed the SQL Agent login account from a local to a system account and back again. The NT account(s) are members of the Administrators group.The only thing I think might be the problem is that the DTS jobs were saved to the local server under a non-SA user name. However I re-saved one package under SA and tried it again, and the job still doesn't run.Any suggestions? I'm at a loss (and so are two other guys at work). Thanks for your help. |
|
|
|
|
|
Jobs Don't Run Anymore