I need to create a task trigger that will run every 5 minutes starting at 5am, check a DB table to see if it has any data in it, and if it does it will succeed and not run again until tomorrow. If there is no data, it should fail and try again in 5 minutes.
Does anyone have any ideas/experience doing something like this? I'm thinking it is some combination of setting the "Task Execution Options >> Number of tries" and the "Configure Trigger >> Max number of executions", but I can't quite figure out how to get it to do exactly what I need...
Thanks!