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 |
|
lw1990
Yak Posting Veteran
85 Posts |
 Posted - 2007-08-02 : 12:19:56
|
| Hi,I have Job setup in SQL Server Jobs, it just move the data around the databases, we called this data massage. But it's failed today, with a message of "The job failed. The Job was invoked by Schedule 9 (TransTables). The last step to run was step 1 (Trans Tables)." in the Job history.the detail message is:Executed as user: MYcompany\SQLSERVICE. ...5', current column value '32398605'. [SQLSTATE 01000] (Message 7998) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) Checking identity information: current identity value '39327109', current column value '39327109'. [SQLSTATE 01000] (Message 7998) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) Checking identity information: current identity value '32398605', current column value '32398605'. [SQLSTATE 01000] (Message 7998) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) Checking identity information: current identity value '39327109', current column value '39327109'. [SQLSTATE 01000] (Message 7998) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (M... The step failed.When I looked at the history of succeeded jobs, the message is: "The job succeeded. The Job was invoked by Schedule 9 (TransTables). The last step to run was step 1 (Trans Tables)". The detail message is:Executed as user: Mycompany\SQLSERVICE. ... current column value '32398605'. [SQLSTATE 01000] (Message 7998) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) Checking identity information: current identity value '39327107', current column value '39327107'. [SQLSTATE 01000] (Message 7998) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) Checking identity information: current identity value '32398605', current column value '32398605'. [SQLSTATE 01000] (Message 7998) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) Checking identity information: current identity value '39327107', current column value '39327107'. [SQLSTATE 01000] (Message 7998) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (M... The step succeeded.They look like same except the failed or succeeded at the end of the message. Please tell me what I need to check to find out the problem that caused the job failed and how to make the job run succeeded.This job was setup to scheduled running, after it's failed, I manually "Start Job" several times, but I got the same failed result.Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-02 : 23:30:57
|
| Anything in sql server log? You can enable package log, next time may get more details if fails again. |
 |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-08-06 : 10:39:05
|
| I will share something that Tkizer once told me that has helped me out loads with troubelshooting jobs and might be a solution for you.Right click properties of the job and make a note of the owner, then remote into your server where the job is held with the owners credentials and manually run the contents of the job 1 step at a time, this will then give you a indication of what is going wrong with the job should it be a user restriction issue or a invalid mapping etc etc ... |
|
|
|
lw1990
Yak Posting Veteran
85 Posts |
Posted - 2007-08-06 : 16:02:02
|
Thank you rmiao and Jim77,I had to use SQL Query Analyzer to go through the Stored Procedure which I setup in the Job line by line, section by section  . Then I fixed the problem.Well, if we can't get enough information in the message, we have to check in this way, even it runs 1000s line of code.Thank you for your help. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-06 : 16:31:47
|
| You can enable package logging, that should give you more info. |
|
|
|
|
|
|
|
|
SQL Agent Jobs Failed