DSXchange

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.

Try setting the warning limit to 1.

Hi DSGuru, I faced similar issue today. There are 0 warnings in this job. The event type of below message is 'Info'. In such scenarios, I would want the job to abort. Is there a way to achieve this.