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.