Program Windows Scheduled Task

[Zigzag]

Hi All,

Does anyone one if it is possible to program a schedule for "Windows Scheduled Task" via VBA?

Reason:- A multi user application is set to give a 5 Min warning at the same time every day. After the 5min the users are politely kicked off.

At that time the Windows Scheduled task opens up the BE (only on 1 PC the fastest). The BE start form has a time event that backs up the BE and compacts and repairs itself then closes the application.

Not pretty I know but it works really well.

This shutdown time can be set/changed on the FE however, when it is the windows Scheduled Task has to also be changed which I would like to do automatically via VBA

Any help would be appreciated.

 

[DJkarl]

Hi All,

Does anyone one if it is possible to program a schedule for "Windows Scheduled Task" via VBA?

Reason:- A multi user application is set to give a 5 Min warning at the same time every day. After the 5min the users are politely kicked off.

At that time the Windows Scheduled task opens up the BE (only on 1 PC the fastest). The BE start form has a time event that backs up the BE and compacts and repairs itself then closes the application.

Not pretty I know but it works really well.

This shutdown time can be set/changed on the FE however, when it is the windows Scheduled Task has to also be changed which I would like to do automatically via VBA

Any help would be appreciated.

Have you looked at the AT command, you could build a batch file or just shell this command with the proper arguments.

From command prompt typing at /?
----------
The AT command schedules commands and programs to run on a computer at
a specified time and date. The Schedule service must be running to use
the AT command.

AT [\\computername] [ [id] [/DELETE] | /DELETE [/YES]]
AT [\\computername] time [/INTERACTIVE]
[ /EVERY:date[,...] | /NEXT:date[,...]] "command"
----------