Hi,
I have the following requirements which I am trying to meet and am struggling to with a single job...
I want a job with a task to be executed when both the following conditions are met -
- after 9am each day
- file has arrived in a directory
If the file has not arrived by 10am I want a notification that it has not. This could be achieved by triggering the job even though the file has not arrived - my task will then raise an error due to the file not being present and I will receive an email notification.
I have created a job which has the processing task and also has 2 dependent triggers -
- Time event trigger for 9am each day
- File event trigger to check when file has arrived in a directory
The problem is around how to trigger the job when the file has not arrived by a certain time. If I set the timeout on the File Event trigger to 60mins it is evaluated every 60 mins and the trigger fires. I want it to only evaluate when the time trigger has been activated, ie - only at 10am, not every 60 mins throughout the day
Effectively what I am after is a Control-M style "late shout" notification. In Control-M you configure the start time of a job and then you can also configure a "late shout" where if the job has not run by a certain time a notification is generated that it has not.
Appreciate any ideas / assistance. Thanks