Windows 10 Task Scheduler - How Do I schedule a task to run only after a value is found in a table...

  • Thread starter Thread starter Rrfjr
  • Start date Start date
R

Rrfjr

Guest
I have a Task Scheduler task that calls an MS Access Function that combines and querys a bunch of tables once a week. It works fine and has been running for years. HOWEVER...one of those MS Access tables is now under the responsibility of another user who is inconsistent as to when he makes his updates. What I have been doing is querying his table after 5pm and when I see an entry for the current date I know its safe to fire off my scheduled task. If I do not see an entry I try again in 30 minutes or so.

I want to automate this this and I am unsure how.

Essentially my task can only run after I find and entry in table: X for the current date.

Any thoughts on how I might do this using task scheduler / Access and or SQl serv? I am thinking the task needs fire off, check if the table entry exists, if so run itself, if not reschedule to try again in 30 minutes.

More...
 
Back
Top