Page 1 of 1

Jobs running after resetting being done

Posted: Tue Jan 13, 2009 8:38 pm
by sujaoschin
I am having 5 jobs which run sequentially namely validate, default, transform, lookup and load. From Validate to lookup, all the jobs ran successfully and while load job was running it throws an 'fatal warning' of below:-

'Unable to find SoftwareResourceLocator start point'.

I reset/stop the load job many times. But still it is in Running mode. Please let me know how to stop this job?

Posted: Tue Jan 13, 2009 9:25 pm
by ray.wurlod
It's not clear what you're asking. By "mode" do you mean status? What it the status of each of the underlying five jobs? How are the job sequence compilation options set?

Posted: Tue Jan 13, 2009 9:40 pm
by sujaoschin
Sequencer of my job 'A" runs Validate, default, transform, look up and load job sequentially. When I check the status of the jobs in Datastage Director, for the first four jobs - the Status is Finished. But the Load job, in Director is in 'Running' status without coming to an end.

I resetted the Load job using the option available in DS Director and 'Stop' menu in Ds Director. But it is still in running- status in DS Director. Any command needs to be provided to change the status of load job from 'Running ' to 'Stop' or 'Reset' mode? Please advise.

Posted: Tue Jan 13, 2009 10:08 pm
by ray.wurlod
Clear Status File option from Director for the Load job.

Posted: Tue Jan 13, 2009 10:16 pm
by sujaoschin
Thanks, Ray. I did as you said and it worked.

Posted: Tue Jan 13, 2009 10:36 pm
by chulett
Make sure you understand that will reset the status to show the job is not running even if it is. That's why it asks you twice "Are you sure?".