DSXchange

I have a controller job where I call many jobs using the code.

I am using a for loop in which I repeatedly calling a job and incase it abort , resetting it and running agian in the loop.

My requirement is, after each itration of the loop it should wait for 30 seconds.

Is there a sleep or any function is availabe in datastage? So that in the jobcontrolm i can add that and my for loop will waot after each iteration

Never tried but please check for help in datastage for Sleep

[/b]

SLEEP seconds

SLEEP hh:mm

NAP milliseconds

Each of these is a statement, not a function. The hh:mm format for SLEEP uses a 24-hour clock, and causes the process to sleep until that time, or not to sleep at all if that time has already passed.