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 |
|
Kimono
Starting Member
3 Posts |
 Posted - 2008-10-21 : 00:23:16
|
| Hello,I am getting Event ID 208 on Step one of a job when running to it's 30 minute schedule, however, when I run the job in SQL Manager manually, it runs fine. What to look at first? I've changed credential from sa to domain account, same errors. Was always running fine until recently.K |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-10-21 : 02:48:00
|
| What does the job do?Could it be permissions? What account does SQL Server run as? What account does SQL Agent run as?If you're doing anything to the OS, the when the job runs scheduled, the account it will use is SQL Agent's service account. When you run it manually through Management studio, it uses SQL Server's service account. If they're different, there may be a problem.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
SQL Jobs Fail but run okay manuall