cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Community Live- Tenant Routed Multicast in VXLAN EVPN Fabric
488
Views
0
Helpful
1
Replies
Highlighted
Beginner

SQL Return Codes not recognized by Tidal

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.

1 REPLY 1
Highlighted
Enthusiast

Hi shmurray1

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

CreatePlease to create content
Content for Community-Ad

Cisco COVID-19 Survey

This widget could not be displayed.