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 |
|
SQL_Rookie
Starting Member
32 Posts |
 Posted - 2007-02-27 : 10:56:19
|
| I have this sql job that has been running for months but last night good an error. I try to see what is in the event viewer and job history and all I can get is thisThe job failed. The Job was invoked by Schedule 49 (Daily Schedule for Sales Process Check). The last step to run was step 1 (Call the PROC).Are there any sys tables I can check to see what went wrong?Where can I find more information to debug on what went wrong? |
|
|
SQL_Rookie
Starting Member
32 Posts |
Posted - 2007-02-27 : 11:22:45
|
| I found it ....there is a table called sysjobhistory that tells me what went wrong. It was a deadlock victim. |
 |
|
|
|
|
|
sql job failing ..need to debug