Store Procedure
Posted: Thu Jan 22, 2009 10:08 am
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
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