Microsoft Task Scheduler

From DataSelf Knowledge Base
Jump to: navigation, search

The name usually used in Microsoft documentation is Task Scheduler. Also known as Windows Task Scheduler or Task Scheduler.

{{#breadcrumb:Main Page}}

Links

Trigger a Pre-defined Task from a Remote Computer

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

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 the clients use the scheduler software they are most comfortable with.

Edit an Existing Task

  1. Expand the folder containing the task in the left-most panel.
  2. Right-click on the name of task in the center panel.
  3. Select Properties.

Run a Task (Execute on Demand)

  1. Expand the folder containing the task in the left-most panel.
  1. Right-click on the name of task in the center panel.
  1. Select Run.


Scheduling a DataSelf Refresh Task using Task Scheduler

Creating a Refresh Task in Task Scheduler -- Step 1
Creating a Refresh Task in Task Scheduler -- Step 2
Creating a Refresh Task in Task Scheduler -- Step 3

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


Creating a Refresh Task in Task Scheduler -- Step 4
Creating a Refresh Task in Task Scheduler -- Step 5

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.

Task scheduler showing 'locked out' error message

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: