|
Posted by joel.sjoo on 12/15/06 12:03
I need some help to solve this problem with some stored procedures.
Sens we use ControlM I need to schedule jobs there and not in SQL. With
a simple batchfile I execute an OSQL from ControlM that start a
procedure that calls the other procedures that should bee used. My
problem are the error handling, how would I do to stop the execution of
SP if one of the fails? Any one got an idea?
I figured out the first simple step below :-)
CREATE PROCEDURE [dbo].[USP_RUNJOB] AS
EXEC DBO.SP_TEST1
GO
EXEC DBO.SP_TEST2
GO
Regard Joel
Navigation:
[Reply to this message]
|