Stopping a multiple instance job

kduke · Post by **kduke** » Fri Oct 10, 2003 9:36 am

DataStagers,

Does anyone know how to stop a multiple instance job? This code does not work:

JobName = 'QaJobHistMI.Mi1'
RunHandle = DSAttachJob(JobName, DSJ.ERRNONE)
JStat = DSGetJobInfo(RunHandle, DSJ.JOBSTATUS)
if JStat = 0 then
JobStatus = 'Running'
JStat = DSStopJob(RunHandle)
end
JStat = DSDetachJob(RunHandle)

Has anyone been able to stop a multiple instance job in a program? I know the Director can do it. Does the dsjob command work?

Kim.

Kim Duke
DsWebMon - Monitor DataStage over the web
www.Duke-Consulting.com

kcbland · Post by **kcbland** » Fri Oct 10, 2003 10:21 am

When you say it doesn't work, do you mean the job doesn't stop? What kind of job are you testing? If it's a BATCH job not using DS API's chances are it won't stop. There are commands that do not honor a stop, such as SLEEP, EXECUTE, etc.

If your job is a Server job it should work as you've coded it. Unless of course, it's stuck waiting on database activity such as a select or a commit.

Kenneth Bland

kduke · Post by **kduke** » Fri Oct 10, 2003 11:51 am

Kenneth

I use this code to stop all my jobs. It works fine with all the jobs tested except a multiple instance server job. The Director can stop the same job. I am not sure what the problem is. That is just the important parts of the code and not all of the BASIC program.

Kim.

Kim Duke
DsWebMon - Monitor DataStage over the web
www.Duke-Consulting.com

spracht · Post by **spracht** » Fri Oct 10, 2003 12:00 pm

Hi Kim,

I had a similar problem in DS version 5.2. Trying to stop an invocation of a job, say 'job1.inv1', I got an error message saying that job 'job1' wasn't running or paused, DSStopJob tried to stop the job without invocation. Ascential delivered a patch file which solved the problem.

Kind Regards
Stephan

kduke · Post by **kduke** » Fri Oct 10, 2003 12:29 pm

Stephan

That is not encouraging but thanks.

Kim.

Kim Duke
DsWebMon - Monitor DataStage over the web
www.Duke-Consulting.com

kduke · Post by **kduke** » Fri Oct 10, 2003 12:41 pm

Stephan

dsjob -stop KimStage QaJobHistMI.Mi1

does not work either. nor:

dsjob -stop KimStage QaJobHistMI

DataStage sux.

Not really.

Kim.

Kim Duke
DsWebMon - Monitor DataStage over the web
www.Duke-Consulting.com

spracht · Post by **spracht** » Fri Oct 10, 2003 7:41 pm

Kim

yes, I also experienced problems with the dsjob command regarding the invocations. dsjob wasn't able to return the correct list of the invocations of a job, usually you get only the job itself. Specifying an invocation as an argument to dsjob, the list will only contain that one invocation.

Kind Regards

Stephan

ray.wurlod · Post by **ray.wurlod** » Sat Oct 11, 2003 1:44 am

Never tried stopping a single instance! Hmm. Food for thought (and work for Ascential engineering methinks).

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

kduke · Post by **kduke** » Sat Oct 11, 2003 8:38 am

Ray

This code stops all jobs but multiple instances. The bug is not in my code.

Kim.

Kim Duke
DsWebMon - Monitor DataStage over the web
www.Duke-Consulting.com