Running/Restartable job hanging

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
przytula
Participant
Posts: 27
Joined: Wed Apr 14, 2004 1:31 am
Location: Brussels Belgium
Contact:

Running/Restartable job hanging

Post by przytula »

we have ds on solaris and had a problem with priviliges on solaris.
the job was aborted, but a sub-job (called from previous job) stays in status Running/Restartable. We tried to stop this job, and even stopped and started the engine again. The job can not be started anymore, as it is running (according the status)
Is there any way to force this or give ds engine the status of stopped ?
Thanks for all info/help
Regards, Guy Przytula
IBM DB2/ORA/SQL Services
Best Regards, Guy Przytula
cmueller
Participant
Posts: 46
Joined: Wed Oct 23, 2002 7:10 am

Post by cmueller »

In Director, select the job and then go to Job menu and then "Clear Status File" which will reset the status of the job to compiled.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Just to add on the answer givven:
this option is available via director only if your project properties(set via DS Administrator) have the allow job administration in director checkbox marked.
this will also cause the cleanup resources option to be available.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply