Hi All,
I have a server job in which an ODBC stage is calling a SQL Server Stored Procedure. This job is scheduled thru BMC scheduler. The job runs fine while the BMC shows it as a failure. Looks like the return code is an issue.
What would be the return code from the DS job in this case.
Currently when the return code =1 No action Otherwise Terminate is the condition in the BMC.
Please advice, thanks
Store Procedure
Moderators: chulett, rschirm, roy
Depends on the options you used in dsjob when scheduling. The -jobstatus option returns the 1 for OK you are looking for, without that a zero indicates success.
ps. Got nothing to do with the fact that your job runs a stored procedure, this applies across the board to all jobs regardless of their design.
ps. Got nothing to do with the fact that your job runs a stored procedure, this applies across the board to all jobs regardless of their design.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Yes, you should be getting the standard DataStage return values from the job:
1 = Finished OK
2 = Finished (see log)
3 = Aborted
Etc. Can you check inside BMC what the actual return code is and verify that it knows a 1 is ok? Out of the box they typically want a 0 for success, from what I've seen. And verify there are indeed no warnings generated in your job's log.
1 = Finished OK
2 = Finished (see log)
3 = Aborted
Etc. Can you check inside BMC what the actual return code is and verify that it knows a 1 is ok? Out of the box they typically want a 0 for success, from what I've seen. And verify there are indeed no warnings generated in your job's log.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers