Microsoft Task Scheduler
The name usually used in Microsoft documentation is Task Scheduler. Also known as Windows Task Scheduler (WTS) or Task Scheduler.
As of 2023 we recommend DataSelf Agent for scheduling. Windows Task Scheduler and DataSelf Agent are supported by DataSelf ETL+.
Links
- http://www.dummies.com/how-to/content/how-to-open-windows-task-scheduler.html
- http://windows.microsoft.com/en-US/windows/schedule-task
- Incomplete - Configuring the Task Scheduler - Incomplete notes on distributing a email newsletter
Trigger a Pre-defined Task from a Remote Computer
- Technet: Run a Task on Demand
- Technet: To run a task on a remote computer See the section titled "To create or manage a task on a remote computer by using the command line"
schtasks /Run [/S <system> [/U <username> [/P [<password>]]]] /TN <taskname>
/TN- The Name assigned to the task in Window's Task Scheduler on the remote computer./S <system>- The Computer name displayed by Control Panel > System on the remote computer.
- Note: It's easy to confuse Task Manager and Task Scheduler ... they are different systems!
Scheduling Any Job or Task
See the instructions below.
Scheduling a DSA AD Job
- "Job" in this context usually refers to executing the DSA AD commands contained in a batch (.bat) file.
- For more: See the instructions below
Scheduling a Excel AD Job
- "Job" in this context usually refers to executing the Excel AD commands contained in a .vbc file.
- See the instructions contained in the Instructions sheet of a Excel AD Controller (a.k.a. Master) file.
Windows Task Scheduler for DataSelf ETL Refresh
As of 2023 we recommend DataSelf Agent for scheduling.
Prior to DataSelf ETL+ for clients with SQL Server we recommend using SQL Server Agent/Job Scheduler to run the ETL refresh. SQL Express, however, does not include a built-in scheduler so the task scheduler program in Windows may have to be used instead. For processes other than the ETL refresh process we recommend clients use the scheduler software they are most comfortable with.
Edit an Existing Task
- Expand the folder containing the task in the left-most panel.
- Right-click on the name of task in the center panel.
- Select Properties.
Run a Task (Execute on Demand)
- Expand the folder containing the task in the left-most panel.
- Right-click on the name of task in the center panel.
- Select Run.
Scheduling a DataSelf Refresh Task using Task Scheduler
With the following in the fields:
Program/script: "D:\Program Files (x86)\DataSelf\DataSelf ETL\Library\dsrefresh.exe"
Add arguments: "0" "MAS 90200 V45"
Start in: D:\Program Files (x86)\DataSelf\DataSelf ETL\Library
(NOTE: The entry in the Start in box is not delimited by double quotes.)
NOTES:
- At one installations the refresh ran for more than 4 hours, so the length of time before time-out would need to be longer.
Troubleshooting Windows Task Scheduler
"The referenced account is currently locked out..." Error Message
Context: I tried to change the task I had scheduled for DataSelf, mistyped the password on saving it, and now it gives a error.
After about 10 minutes, it unlocked and allowed me to save. Though it had unchecked the “run with highest privileges” option on me, and I had to log back in again and change that. (And type the password to save the changes VERY carefully!)
Here are a couple of discussions about what to do about it that I found:
