How to abort a parallel job or sequence if it is running more than 30 minutes?
I searched the forum and I couldn't find any particular answer. We use a scheduling tool and that creates a ticket if it exceeds max time out.
But I need to abort the datastage job. Just want to know if there is any environment variable for this.
Abort job if ran more than 30 minutes
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
The data in the file is very less. The job hangs due to DS administration issues which I am not sure of.
If I abort the job so it will run again as the job is scheduled within short intervals of time if not it will wait until someone manually go into director and abort it. The job runs throughout the day.
If I abort the job so it will run again as the job is scheduled within short intervals of time if not it will wait until someone manually go into director and abort it. The job runs throughout the day.
-
- Participant
- Posts: 34
- Joined: Tue Feb 26, 2013 9:36 am
- Location: Chicago
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a Constraint expression that tests how long it has been since the job started and send the row down an output link with a row count limit of 1.
In a sequence remember the job start time using a User Variables activity and, at specific places in the sequence, compare this against current time.
Neither of those will work if the "running" time is increasing because of waiting on an external resource, such as a lock (deadlock) in a database.
Ideally, as others have noted, monitor externally to the job/sequence and issue Stop request.
In a sequence remember the job start time using a User Variables activity and, at specific places in the sequence, compare this against current time.
Neither of those will work if the "running" time is increasing because of waiting on an external resource, such as a lock (deadlock) in a database.
Ideally, as others have noted, monitor externally to the job/sequence and issue Stop request.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.