Create 3 jobs. 2 jobs with no schedules ([no schedule] for schedule) and 1 job scheduled to run and control other 2 jobs. That job should be of script type
and have script code like JobRun "1st job name here"
Wait 25200
JobRun "2nd job name here" This will start second job 7 hours after the first job completes.
In case if you need to your start second job 7 hours after start of the first job use script like the following Dim Timer1, number
Dim Timer2, Number
Dim WaitTime, Number // run first job and calculate job duration
Timer 0, Timer1
JobRun "1st job name here"
Timer Timer1, Timer2
// convert from milliseconds to seconds
Divide Timer2, 1000, Timer2 // calculate how long to wait before launching next job
// 7 hours is the same as 7*60*60 = 25200 seconds
Subtract 25200, Timer2, WaitTime Wait WaitTime // run second job
JobRun "2nd job name here" : I'm having trouble figuring out how to have one job run another, but I want
: there to be a 7-hour delay before the second one starts up. The reason I
: need this is because the two jobs cross a date boundary and they are
: affected by bank holidays, so I need them to be coordinated together,
: rather than separately scheduled.
|
