Sequence Issue

sush26283 · Post by **sush26283** » Fri Mar 23, 2012 7:29 am

I have a sequence job, which looks like this..

Job_activity1--->job_activity2--->....job_activityN

and at the trigger(all of them) I have the custom (conditional) with expression as Job1.$JobStatus = DSJS.RUNWARN, so that the trigger is initiated even if there is any warning.

I had this scheduled, but after it ran all fine I noticed that only Job_activity1(the first job) ran and it did not trigger the next to run.So, the whole sequence did not run but only the first part, and the job log shows as successful.

Can anyone tell me where am making the mistake, due to which the whole sequence did not run.

Thanks in advance

chulett · Post by **chulett** » Fri Mar 23, 2012 8:06 am

That trigger means the next job only runs when the previous job finishes with warnings. A successful run will not trigger the next job. You need to check for RUNOK or RUNWARN.

sush26283 · Post by **sush26283** » Fri Mar 23, 2012 8:14 am

so what you are saying is that I should use the expression as Job1.$JobStatus = DSJS.RUNWARN or Job1.$JobStatus = DSJS.RUNOK in all of the job activity stages

chulett · Post by **chulett** » Fri Mar 23, 2012 8:51 am

Yes. If you want to allow warnings to be ok.

sush26283 · Post by **sush26283** » Fri Mar 23, 2012 9:20 am

Thank You Sir!!!