July 24, 2003 at 9:17 am
...---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [SQLSTATE 01000] (Message 0) SAVING PRE-RESTORE DATA FOR GRD (24 Jul 2003 14:21:11:760)... [SQLSTATE 01000] (Message 0) SAVING GRD Pre-Restore Data... [SQLSTATE 01000] (Message 0) ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [SQLSTATE 01000] (Message 0) SAVED PRE-RESTORE DATA FOR GRD (24 Jul 2003 14:21:13:387)... [SQLSTATE 01000] (Message 0) ------------------------------------------------------------------------------------------------------------------... The step failed.
In the stored procedure I have print statements as above. Why does the job state failure when the script was successfull
July 24, 2003 at 12:58 pm
A result code of failure was returned. I believe this is 1.
Steve Jones
July 24, 2003 at 2:12 pm
Also check that in the job, in the Advanced tab, you don't have 'Quit the job reporting failure' on the success action.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply