Handling two different jobs
Posted: Fri Nov 06, 2009 5:22 am
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
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