Hi All,
I have two server jobs in my project.First job say Job1 loads data from PRODUCT to FACT_PRODUCT table.Second job Say Job2 also follows the same procedure except it takes only those rows from PRODUCT table which are updated or newly inserted after completion of Job1 or after some timestamp.
Here i would like to execute these jobs conditionally based on the initial data load.If FACT_PRODUCT table doesn't contain any records then the execution on job sequence should be like Job1=>Job2 and if FACT_PRODUCT contains already certain records then Job2 should be executed directly.
Please let me know how i can achieve this ?
For this shall i use job sequence or whether needs to make setting in server job itself.
Waiting for Reply
Thanks,
VJ
Handling two different jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Oct 01, 2008 10:30 am
Handling two different jobs
IBM Websphere Datastage Certified Professional
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For example the precursor job could simply write the count into its user status area, which the triggers from the precursor job's Job activity can interrogate directly to determine what happens next.
Code: Select all
precursor -----> Job2
|
+-----> Job1 -----> Job2
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.