To do job Abort in server

asnrece1 · Post by **asnrece1** » 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

datskosaraju · Post by **datskosaraju** » 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

ArndW · Post by **ArndW** » 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.

ray.wurlod · Post by **ray.wurlod** » 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