Window scheduler task

[DevAccess]

Hello

I have one database which is runs every week from windows scheduler to perform some import functionality from CSV files.

However I would like to run one another activity which should be done in every six month ( twice in year ), this is also import functionality.

I was wondering how could I accomplish this, the same database runs on every weekend as well.

For this six month activity I created table which keeps of tracking of last run date and I am thinking of use datediff function but this does not seems to be good solution.

Please advise how can I accomplish this.

 

[isladogs]

I have a database which has 3 different scheduled tasks associated with it.
In my case, these run each day at 09:30, 14:30 and 22:00 though not at weekends or in school holidays!

These tasks work by using a named command line switch or 'argument' for the file opened by the scheduler
For clarity, lets call them /morning /afternoon /overnight

When Access starts, the startup form checks the argument used and runs the appropriate code

Can you use a similar method for your scenario as well?