Jobs running after resetting being done

sujaoschin · Post by **sujaoschin** » Tue Jan 13, 2009 8:38 pm

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?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 13, 2009 9:25 pm

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?

sujaoschin · Post by **sujaoschin** » Tue Jan 13, 2009 9:40 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 13, 2009 10:08 pm

Clear Status File option from Director for the Load job.

sujaoschin · Post by **sujaoschin** » Tue Jan 13, 2009 10:16 pm

Thanks, Ray. I did as you said and it worked.

chulett · Post by **chulett** » Tue Jan 13, 2009 10:36 pm

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