HI ,
I have a job which has been crashed the status in the director is showing running , I have tried stopping the job in many ways--
1) From the director
2) From Command prompt Dsjob-stop
3) Killing the process in unix
4) shutdown the datastage server and restarted but the job is still running.
5) I went into the job menu in the director but clear status file option is not available as the job is still running...I want to compile this job and run
can any one have better ideas to stop the job or any one know where the log file written in the server directory.
I would appreciate any suggestions...
Thanks
Ashish Arora
Reset the Job status
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What makes you so sure that the job is still running?
What Director's status view is reporting is the last time the job reported its status back to the status table. If it had been killed without the opportunity to update the status table, there's no way that the Director can read any other status than "running".
Use the "Clear Status File" tool in Director to reset the status table (which is actually a hashed file).
What Director's status view is reporting is the last time the job reported its status back to the status table. If it had been killed without the opportunity to update the status table, there's no way that the Director can read any other status than "running".
Use the "Clear Status File" tool in Director to reset the status table (which is actually a hashed file).
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.
Re: Reset the Job status
No such... it is always available regardless of status, which is why it does the 'Are you really sure you want to do this?' stuff.Ashish wrote:5) I went into the job menu in the director but clear status file option is not available as the job is still running...
You have to 'Enable job administration in Directory' for the Project in the Administrator for those options to be enabled.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Reset the Job status
I agree but I actually have the same situation right now. I have a job with running status which, when selected, the "Clear status" option is disabled. When I select another job, the option is enabled.chulett wrote:No such... it is always available regardless of status, which is why it does the 'Are you really sure you want to do this?' stuff.Ashish wrote:5) I went into the job menu in the director but clear status file option is not available as the job is still running...
You have to 'Enable job administration in Directory' for the Project in the Administrator for those options to be enabled.
I have the "Enable job administration..." option set for all my projects.
Ideas?
I did find this article in the Ascential KB that recommends one solution: https://www.ascential.com/eservice/know ... =T30760501
Going to give it a try....
Going to give it a try....
Just noticed that the item marked as running is an instance (uses an invocation id). When I select the job itself, "Clear status" is enabled. It is only when I select the instance of the job that "Clear status" is disabled. That makes sense...
So, I should just be able to delete this instance and move on, right?
So, I should just be able to delete this instance and move on, right?
RodBarnes wrote:I did find this article in the Ascential KB that recommends one solution: https://www.ascential.com/eservice/know ... =T30760501
Going to give it a try....
That helps explain what's going on, but that being said I don't have that issue with multi-instances jobs - they still show the 'Clear status' option as enabled for me.
If you do the 'Clear' from the main job itself, all of the 'instance' information will be removed. If nothing is actually running, I'd say that should be the tack you take.
If you do the 'Clear' from the main job itself, all of the 'instance' information will be removed. If nothing is actually running, I'd say that should be the tack you take.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers