Online Documentation for DB Extract for SQL Server

Scheduled Task sections


Section [#ScheduledTask#] stores values set on Step 8 of Wizard application.

 

The configuration parameters are listed below.

 

TaskType

0 = Run the scheduled task once

1 = Run the scheduled task daily

2 = Run the scheduled task weekly

3 = Run the scheduled task monthly

 

ScheduledPrefIndex

0 = Run extraction now

1 = Run extraction now and create Windows scheduled task

2 = Create Windows scheduled task only

 

SchellTime

Stores the scheduled task execution time

 

ScheduledDate

Stores the scheduled task execution date (applicable only for TaskType = 0)

 

WeeklyList

The days of the week when the task is scheduled to run (applicable only for TaskType = 2)

The value of this option is a list of zero ("0") and one ("1") values

Each value corresponds to a certain day of the week in the following order:

Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday

e.g. WeeklyList=1,0,0,0,1,0,0 indicates running scheduled task weekly on Mondays and Fridays

 

DaysList

The days of the month when the task is scheduled to run (applicable only for TaskType = 3)

The value of this option is a list of zero ("0") and one ("1") values

Each value corresponds to a certain day of the month in the calendar order

 

SeparateTask (applicable only for TaskType = 3)

0 = Create a single scheduled task for all selected days of the month

1 = Create a separate scheduled task for each selected day of the month

 

TaskDomain

Windows domain of the user specified to run the scheduled task

 

TaskUserName

Windows user name specified to run the scheduled task

 

TaskPassword

Windows user password specified to run the scheduled task

 

NotCloseConsole

0 = Close the console window after execution of the scheduled task

1 = Do not close the console window after execution of the scheduled task

 

 

Section [#Comment#] stores your comment for the template file

 

e.g. Line0 = Template1 for metadata and data extraction