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 |
|
qwertyjjj
Posting Yak Master
131 Posts |
 Posted - 2007-07-17 : 06:04:45
|
| I have setup a simple job that should run a stored procedure nightly.Every time I test it the job fails but I can't find the error message to see what is wrong.DO I have to add error tracking and an output file?I can't find anything in the history.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-17 : 12:49:51
|
| Did you select the option to see details when viewing the job history?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
qwertyjjj
Posting Yak Master
131 Posts |
Posted - 2007-07-18 : 06:27:28
|
| Executed as user: usera. Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-18 : 11:41:14
|
| Check Microsoft knowledge base articles 823429 and 811031, they may work for sql2k5. |
|
|
|
|
|
|
job is failing