Back to top

DemandTools Help

for Scheduled Processes

Windows XP Professional

 

   
October 15 , 2007
 

!!!!!!!!!!!!!!!!!SCHEDULED PROCESSES SHOULD ONLY BE RUN BY ADVANCED DEMANDTOOLS USERS. !!!!!!!!!!!!!!!!!!!!!!!!!!!

AUTO LOGIN AND SAVE PASSWORD CHECKBOXES MUST BE CHECKED.

 

GO TO:

SETTING UP THE SCHEDULED TASK

DEMANDTOOLS TASKS YOU CAN SCHEDULE:

MODIFYING TASK, SCHEDULE, SETTINGS

 

OVERVIEW

Utilization of Windows Scheduler allows saved scenarios from DemandTools to run on a scheduled basis.

Back to top

SETTING UP THE SCHEDULED TASK

STEP #1 - The first screen simply describes the wizard that you will be using.

STEP #2 - In this step you select DemandTools as the program you want to run

STEP #3 - This is where you name your task and choose the frequency that you would like the scheduler to run it. Your selection at this step will be the determining factor for the options given to you in the next screen. 

STEP #4 - Because this example was for a freqency of Weekly, we need to tell windows what day, time, and if we want it every week, every other week, etc.


COMPLETING THE WIZARD

The final item to complete setting up a wizard is to enter the username and password (if used) on the computer being utilized.

Back to top

DEMANDTOOLS TASKS YOU CAN SCHEDULE

NOTE:  The commands must always be listed one a time, and start and end with a double quote.  "Start DemandTools" "Start the Scenario" "File you want to save as or use"

MassEffect Export:  

First set of commands in quotes starts the DT Program, Second set of commands in quotes loads the MassEffect Scenario, Third set of commands in quotes tells Windows what file name you'd like your export saved as (in this example the scenario to load is in a folder called ME_Scheduled_Jobs, the scenario is called ME_sched_export and the file to save it as willl be ME_export.xls:

"C:\Program Files\DemandTools\DemandTools.exe" "C:\ME_Scheduled_jobs\ME_sched_export.DExml" "C:\ME_scheduled_jobs\ME_export.xls"

MassEffect Insert, Update, or Delete:

The full path here starts DemandTools in the first command, loads the MassEffect scenario with the second command and the third command gives the input file.  In this example there is a folder called ME_Scheduled_jobs where the scenarios are saved, the input file for the insert, update, or delete is saved in the same folder.

"C:\Program Files\DemandTools\DemandTools.exe" "C:\ME_Scheduled_jobs\ME_sched_insert.MExml" "C:\ME_scheduled_jobs\ME_insert.xls"

MassImpact:

"C:\Program Files\DemandTools\DemandTools.exe" "C:\ProgramFiles\DemandTools\MassImpactScenarios\ContactMailing(blank)_eq_AccountBilling.MIxml"

Single Table Deduplication:

"C:\ProgramFiles\DemandTools\DemandTools.exe" "C:\ProgramFiles\DemandTools\Scenarios\Friday_ScheduledAccountDedupe.ddxml"

MODIFYING THE TASK, SCHEDULE, SETTINGS

There are two ways to access this screen:

  1. Check the "Open advanced properties for this task when I click Finish" box on the final Scheduled Task Wizard Screen
  2. At the Schedule Task Screen you can either double click the name of the task or right click it and go to Properties

Choose the tab you'd like to edit or review, when complete, click Apply and then click OK.


 
Back to top