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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2006-09-20 : 13:59:02
|
| I added some job to run at mid-night. Sometime, job failed to run. I like to know what happened.Where to check the job failed log info? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-20 : 14:02:25
|
| Just right click on the job, go to job history, then check the box to see the details.Tara Kizer |
 |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2006-09-20 : 14:29:05
|
| It only tell me "the job was invoked by schedule..." It does not help. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-20 : 14:54:29
|
| You didn't check the details then. Once you click the check box, more lines will appear for each run of the job.Tara Kizer |
|
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2006-09-20 : 15:08:05
|
| Thank you for help. I got this message:Executed as user: Intra-query parallelism caused your server command (process ID #54) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1). [SQLSTATE 42000] (Error 8650). The step failed.I do not understand what is going wrong. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-20 : 15:29:54
|
| I googled your error message and found this:http://support.microsoft.com/?kbid=837983If that doesn't help, I'd suggest looking at the other google links as well. If that still doesn't help, you may need to contact Microsoft directly for this.Tara Kizer |
|
|
|
|
|
|
Where to check the job failed log info?