DSXchange

Posted: **Mon Jul 06, 2009 6:31 am**

Hi all,
Can you help on , how to abort the job in server by using transformer stage or any routine ?
my job is multiinstance job and input ODBC stage which called the Stored procedure and return the value 0 or 1 , for value 1 i wanted to abort the job .
can you help this requirement.

thanks
satya

Posted: **Mon Jul 06, 2009 6:43 am**

Hi Satya,

There was a similar type of discussion few days ago.

Hope this helps

viewtopic.php?t=127966&highlight=abort

Posted: **Mon Jul 06, 2009 6:47 am**

Put a link into your transform stage with a constraint of "SQLOutputLink.REJECTED" (Assuming your link to your DB connection is called "SQLOutputLink")and then put limit of that output to abort after 1 row.

Posted: **Mon Jul 06, 2009 6:13 pm**

I always counsel never to design server jobs to abort. Issue warnings, certainly, but retain control.

DSXchange

To do job Abort in server

To do job Abort in server

Re: To do job Abort in server