If you get an error while executing second procedure then what is the error message? (check the job log for details) Do you need to issue a commit between procedures? Do you have autocommit turned on or off? : I have a job that calls several stored procedures
: Using Database executions. Eg. : DatabaseExecute( "exec stored_proc1")
: DatabaseExecute( "exec stored_proc2")
: DatabaseExecute( "exec stored_proc3") : However only the first stored procedure
: executes sucessfully : Do I have to break-up the Job into several
: smaller ones?
|
