Conditional datastage job run

vijay · Post by **vijay** » Mon Jun 21, 2004 2:22 pm

Hello All:

Can you help me with a best practice to run a dependent job based on condition (e.g. record count in a particular table <= 200,000)? If the record count is > 200,000, then the job should not be run.

Thanks,
T.Vijay

roy · Post by **roy** » Mon Jun 21, 2004 2:54 pm

Hi,
well here are some things for you to check out :
1. sequence job and nested condition.
2. Routines DSGetLinkInfo() DSGetJobInfo().
3. setting a user status for a job.
4. writing DS Basic code.
5. Building your own routine perhaps as a befor routine.

all you need is a search away here or in the DS docs you have.

IHTH,

roy · Post by **roy** » Mon Jun 21, 2004 3:03 pm

Hi,
forgot about the table part, simply get the count(*) in any regular job.
set a user status to that job with this count (yes you still need to write your DS Routine for setting the user status something like:

Code: Select all

 $INCLUDE DSINCLUDE JOBCONTROL.H
 Call DSSetUserStatus (UserStatus)

)
now you could run this in a squence and use the nested condition to branch to the job or not hence running or not depending on the condition outcome.
if you want you can do several variations, how ever I think this is the most simple way to implement it.

Good Luck,

vijay · Post by **vijay** » Wed Jun 23, 2004 1:53 pm

Thanks so much Roy!