Hi,
We are executing SQL procedures using Before-Job subroutine - ExecTCL.(This approach was suggested by IBM as our procedures did'nt run as expected from before/after sql in Dynamic RDBMS stage. We have created VOC entry & are using Exec TCL)
If Exec TCL fails, it gives an error in log but doesnt abort the job.
**********************************************************
[DataDirect][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'usp_GetLastBusinessDate', database 'PowerAgentCommon', owner 'dbo'.
**********************************************************
We would like our jobs to abort in such scenarios. Is this possible?
Thanks,
Preethi.
Fail job during ExecTCL failures.
Moderators: chulett, rschirm, roy