Skip to Content
May 23, 2009 at 06:10 PM

Schedule Dependency Scenario



I have a scenario that I cannot seem to find the right combination to get to work. I will try to describe.

Job "A" runs daily at 1:00am

Job "B" must

1. Wait for Job "A" to finish AND

2. Cannot start before 2:00am AND

3. dependent upon the existence of a file.

The catch is that the file that Job "B" is dependent does not get generated every day. In fact, it only gets generated once per month. As you can see then Job "B" really only runs once per month.

I set up an "event" for the file and ties to Job "B". call it "FILE_EVENT"

I set up a "raise" event which gets raised upon a complete status of Job "A".

I set up a time window from 2:00am to 3:00am and upon submit connected it to Job "B" with EVERDAY submit frame.

Basically, I want Job "B" to wake up everyday at 2:00am and check to see if the COMPLETE flag is raised AND the FILE_EVENT is raised. If both don't get raised before 3:00am then try again tomorrow at 2:00am

Currently if the file does not exist: the window closes; Job "B" does not run; and then reschedules for the next day which is perfect except that according to the new job instance created the COMPLETE flag is still raised. Therefore the next day if the file does exist Job "B" will start at 2:00am regardless of whether Job "A" for that day had completed yet.

I know its confusing and my attempt at a solution above is just 1 of a dozen that I have tried to no avail. Any help would be greatly appreciated.

Kind Regards,

David Carr