Error in Sequence

sundar · Post by **sundar** » Fri Feb 10, 2006 5:14 am

Hi all,

I am having 5 jobs in the sequence,I want all the 5 jobs to run first
and for the second time,I want to skip the second job,its working well for the first time with execution action reset only and for the consecutive run it gives a fatal error.Is there any option to do this.

Error calling DSRunJob(job2_09L2), code=-2 [Job is not in the right state (compiled and not running)]

With Regards,
Sundar.

ArndW · Post by **ArndW** » Fri Feb 10, 2006 5:38 am

I am not clear on exactlywhat you are intending to do; but the error messages means that when you are trying to reset iyour job it is most likely still running.

sundar · Post by **sundar** » Fri Feb 10, 2006 6:03 am

Hi Arndw,

For the first time i want all the jobs to run.When i run the sequence for the second time onwards, it should skip the second job.

With Regards,
Sundar.

ArndW · Post by **ArndW** » Fri Feb 10, 2006 6:19 am

How do you differentiate a first and a second run in your sequence? It seems that the first run you start the job #2 and don't wait for it to complete, so when you call it a second time it is still running and causes the error you posted.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 10, 2006 3:10 pm

In your job activities, specify "reset if required, then run" as the run mode. Skipping is managed via the compilation options in the job properties window of the job sequence itself; the check box names are quite self-explanatory, and there's always Help.

kumar_s · Post by **kumar_s** » Sat Feb 11, 2006 8:01 am

HI,

If you intend to run the second job for very first time and not from second run onwards, then you can built your own logic to acheive. Use WaitForFile activity after Job1 and trigger if after the first job finish ok.
In WaitForFile stage, just check for some indicator file say 'Indicator.txt'.
Create two output link from WaitForFile stage. Introduce the Job2 to one of the link where the trigger type is Failed.
Another link with the trigger type as OK. This link and and output of the Job2 link connected to a Sequencer with the mode of Any.
After the first run you can just touch the indicator file either by Execude command Activity or by AfterJobSubroutine.

So that from second run, the waitforfile activity after sensing the file will trigger directly to sequencer and skip the Job2.

-Kumar