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
To do job Abort in server
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 48
- Joined: Tue Nov 25, 2008 11:10 pm
- Location: Des Moines,IA
Re: To do job Abort in server
Hi Satya,
There was a similar type of discussion few days ago.
Hope this helps
viewtopic.php?t=127966&highlight=abort
There was a similar type of discussion few days ago.
Hope this helps
viewtopic.php?t=127966&highlight=abort
"It's easier to go down a hill than up it but the view is much better at the top"
-Bennet,Arnold
-Bennet,Arnold
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: