Stopping a running job ? (Without Director)

ady · Post by **ady** » Thu Dec 28, 2006 8:37 am

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 ?

DSguru2B · Post by **DSguru2B** » Thu Dec 28, 2006 8:38 am

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 ???

ds_developer · Post by **ds_developer** » Thu Dec 28, 2006 8:50 am

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

ady · Post by **ady** » Thu Dec 28, 2006 8:51 am

I tried running the job when I returned in the morning. it says the job has been running all night.

And YES its writing to 2 OCI tables. But its supposed to insert just 1 row in each of them.

DSguru2B · Post by **DSguru2B** » Thu Dec 28, 2006 8:55 am

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

ady · Post by **ady** » Thu Dec 28, 2006 9:00 am

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?

chulett · Post by **chulett** » Thu Dec 28, 2006 9:13 am

No, it just means you killed yourself.

DSguru2B · Post by **DSguru2B** » Thu Dec 28, 2006 9:16 am

chulett wrote:No, it just means you killed yourself.

Craig, your gonna scare the poor fellow. He means, killed it yourself.

chulett · Post by **chulett** » Thu Dec 28, 2006 9:18 am

Specifically, I meant the 'it' he killed was his current connection.

DSguru2B · Post by **DSguru2B** » Thu Dec 28, 2006 9:19 am

I know, just having a little fun

ady · Post by **ady** » Thu Dec 28, 2006 9:39 am

Its working now ..... Think the process got killed ( maybe by the DBA, Donno yet

)

I recompiled the job and am running it again .... lets see how it goes this time around! .. thanx guys

ray.wurlod · Post by **ray.wurlod** » Thu Dec 28, 2006 4:17 pm

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.