Fail job during ExecTCL failures.

sspreethi · Post by **sspreethi** » Mon Jun 23, 2008 9:23 am

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.

DSguru2B · Post by **DSguru2B** » Mon Jun 23, 2008 10:37 am

Try setting the warning limit to 1.

snt_ds · Post by **snt_ds** » Tue Sep 02, 2008 11:49 am

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.