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...
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...