SQL Return Codes not recognized by Tidal

shmurray1 · ‎05-05-2017

We have jobs that use the MSSql Adapter to execute a stored procedure. The stored procedure use TRY/CATCH. I an error occurs the statements in the CATCH execute, but the Tidal job completes normally. I have tried using RETURN(), RAISERROR, and THROW in the CATCH block, in all cases the job in Tidal goes to a "Completed Normally" status. I have executed the SQL in SSMS and verified that it is returning an error status.

Is there a way to pass a return code from SQLServer to Tidal and force a job to "Complete Abnormally"?

We are using TES 6.2.1.466 and SQLServer 14.

Derrick Au · ‎06-06-2017

Hi shmurray1

Since the error status can be verified under SSMS -- is the error string pretty static? If that is the case, then you can try setting within Job Definitions >> Run tab >> Tracking >> Scan output: Abnormal String(s), then enter the abnormal string. When Tidal sees the abnormal string, then your job will complete abnormally as expected.

Regards,

Derrick