I'm not a Server expert, but I think Server limits you to set schedules (weekly, monthly, daily, etc).
There's a way you might be able to cheat this-- though you'll need to do a little programming.
Start by creating a simple BAT file that will refresh your extract via TABCMD.
Next, use a platform like good ole Access-- along with a table of your refresh dates-- to call the BAT file and check off that the refresh has been completed for that date.
Last, use Task Manager to open and execute the Access query each day.
It's an admittedly messy solution (and the moving parts give multiple points of potential failure) , but it may work for you.
It might be easier to skip the Access part all together and instead poll the current date and use branching IF/OR statements within the BAT file itself, then execute the BAT file daily using Task Manager.
One limitation of Task Manager is that (I believe) it requires your computer to be on. If you shut it down over the weekend, your extract may not be refreshed
Others may have better bullet-proof ideas... but I hope this gives some inspiration! Let me know if you have questions and good luck to you! --Michael
Thanks for this - it is super helpful! This could be a way round the restrictions on Server's scheduling.
So - using Task Manager to schedule, no problems, I can do that. Creating a BAT file for the refresh - done and working all fine.
What I'm struggling with still is the date part - if you could help me, that would be greatly appreciated!
You mention two ways - via access or using an IF/OR statement. I'm not familiar with using Access queries, but I will look them up now, or adding in the IF statement, I'm not sure how to write it in the CMD. Any suggestions or articles you could point me in the right direction of?
I was able to find details on getting the current date here...
IF statements are detailed here:
While I've not used it, it seems like if you have the MMDDYYYY one could set up a number of IF statements to trigger a refresh using just a BAT statement.
I created an Access program to automatically copy key programs. While this required A LOT more programming, I *was* able to include a "save success" flag which means even if my computer is shut off, it recognizes the file wasn't saved at the correct time and saves it ASAP. This, however, requires lots of programming.
If this solves your issue or is helpful, please mark it as so
Good luck and let me know if I can assist more. --Michael