Posted Thu, 21 Apr 2022 20:45:55 GMT by Greg Brown Lead Data Warehouse Analyst
Let's say I have a job with various conditions and those conditions are met,  normally,  between midnight and 3:00am and the job triggers.   Is there a way in Automate to trigger a notification alert if those conditions haven't been met by 4:00am?  Sort of a "missed schedule" scenario,  but I don't want to put a 4:00am schedule on the job.  I'd like it to complete on it's own earlier as the conditions are met and only let me know if it wasn't able to run before 4:00am which would indicate a problem with the triggering conditions.  
Posted Tue, 28 Jun 2022 21:32:08 GMT by Alex Escalante
Hello Greg,<br> <br> You can use the format date/time action to grab the time when the workflow completes. This will tell you the exact time of completion.&nbsp;<br> <br> If the workflow produces a file, you can have a second workflow check for that file to be created by a certain time. If it doesnt produce a file, you can have the first workflow create a temp file.

You must be signed in to post in this forum.