COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: bala1709 on 31 Jul 2009 02:26:31 PM

Title: Parent child control in job
Post by: bala1709 on 31 Jul 2009 02:26:31 PM
Hi,

I have 2 jobs, the job1(child) should start loading only after completion of job2(parent). Both the jobs were schduled on the same time. Is there any way in data manager to check the completion stauts and then start.

Thanks in Advance
Bala
Title: Re: Parent child control in job
Post by: UseCog on 01 Aug 2009 09:58:15 AM
you can do this by keeping the status of these 2 jobstreams into a table and check using a condition node before the start of the second job starts.

I dont think there is another way using DM. Let me know if there..

Regards
Title: Re: Parent child control in job
Post by: SSNCOG on 18 Aug 2009 02:52:20 AM
Create another jobstream and add parent and chaild jobs as note to this.Create a variable(BOOLEN) and add a condition node after the parent job.write a condition as follows
If ($variable)
  THEN
       Return TRUE;
  ELSE
       Return FALSE;
add a child job after the condition node.
you can add email node to notify the status of the parent job immidiatly after the condition node/parent job.

you can view the status in log files.

Cheers,
SSNCOG