Stopping a running job ? (Without Director)
Moderators: chulett, rschirm, roy
Stopping a running job ? (Without Director)
I have a problem with a job which dosent stop from the director. It bee running all night. Is there a way to stop it from other than the director ?
What is the job doing. Is it accessing a database. Give a call to your dba and ask him to kill the thread that was generated by that id. Some jobs can be a pain when it comes to stopping them. OR maybe it stopped and the status is not updated. How do you know its still running ???
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
There are a couple of ways to "stop" a job in Director. You should tell us what you've tried. Here are the options:
1. highlight the job and hit the 'stop' button
2. go to Job|Cleanup Resources (if enabled on this project) You'll have to find the process (PID) of the job. Then log it out/clear the locks. You should read the documentation and/or have some experience with this.
John
1. highlight the job and hit the 'stop' button
2. go to Job|Cleanup Resources (if enabled on this project) You'll have to find the process (PID) of the job. Then log it out/clear the locks. You should read the documentation and/or have some experience with this.
John
As i suspected. Now give your dba a call and ask him if there are any alive threads from your id, or whatever id is accessing the database. If he says yes then they must be hung. Ask him to kill it at the database level. This will cause your job to abort. Never stop a job that is accessing a database, the connection doesnt die at times and then problems occur
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ds_developer wrote:There are a couple of ways to "stop" a job in Director. You should tell us what you've tried. Here are the options:
1. highlight the job and hit the 'stop' button
2. go to Job|Cleanup Resources (if enabled on this project) You'll have to find the process (PID) of the job. Then log it out/clear the locks. You should read the documentation and/or have some experience with this.
John
I tried Highlighting the job and clicking on it .
And when I go to Job|Cleanup Resources, Processes>click on show all and click on my Id and logout ...... It says "Error Calling Subroutine: *DataStage*DSR.PLADMIN (Action=2); Check datastage is setup correctly. Subroutine failed (30107)).
This means that it not setup for the project right?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can use the -stop option in the dsjob command line interface to issue a stop request to a running job.
Note, however, that the "running" status reported in Director may be out of date, but the job was unable to update it. Search the forum for more complete description.
Note, however, that the "running" status reported in Director may be out of date, but the job was unable to update it. Search the forum for more complete description.
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.