How to: |
Reference: |
DataMigrator provides several ways to run data and process flows. In addition to executing flows immediately, you can use the DataMigrator internal scheduler to run requests off-hours, on a recurring basis, or on specified days of the week or month.
Alternatively, you can schedule or execute a flow from an application other than DataMigrator. For details, see Event-Based Scheduling.
You can also disable a scheduler without removing the Schedule object from the flow.
You can schedule a process flow to run in the following ways:
When the scheduler checks, it executes all flows scheduled to run in the period of time since the scheduler last checked.
For scheduled flows to run, the scheduler must be running. On the Scheduler Configuration dialog box, the sched_autostart drop-down menu must be set to yes.
Note: You can also add or change schedule properties from the Web Console.
The Properties pane opens.
The Properties pane opens.
Tip: If you wish to stop a query from executing regularly, you do not need to change the schedule. Instead, set Schedule Status to Inactive in the Schedule attribute pane.
The Properties pane opens.
Tip: If you wish to stop a query from executing regularly, you do not need to change the schedule. Instead, set Schedule Status to Inactive in the Schedule attribute pane. For details about setting flow properties, see Setting Flow Properties.
You can schedule a process flow to execute or not execute on holidays. The Holiday option is available when Recurring or Multi-Day are selected in the Schedule Type drop-down menu. For more information, see Specifying Holiday File.
Note: You can only schedule the flow to run on holidays after you create a holiday file.
The Properties pane opens.
Excludes a run on desired holidays.
Only run on desired holidays.
To verify that the holiday schedule is set, in the navigation pane, expand the Workspace folder. Then expand the Special Services and Listeners folder. Right-click SCHEDULER and click Scheduled Events. The Scheduler/Scheduler Events report should list scheduled flows by the holiday set date.
You can schedule a process flow to run whenever the DataMigrator server is started. This option is useful that need to run all of the time, for example, when using Change Data Capture or File Listener capabilities.
The Properties pane opens.
You can disable a the schedule of a flow from the Properties pane for a schedule.
The Properties pane opens.
To access the Schedule attribute pane shown in the following image, right-click the Start object and click Properties.
The Schedule attribute pane contains the following fields and options:
Determines if there is a schedule and if so, whether the schedule is active or inactive.
Determines whether a process flow will execute once, on a recurring basis, on several specific days (Multi-Day), or when the server starts.
Specifies the interval in which a process flow will be executed. For example, if you select Month as your Interval Type, and select 2 as your Interval Value, the flow will execute every two months. This option is only available if the schedule type is set to Recurring.
Specifies the frequency at which a process flow will be executed. For example, if you select Week as your Interval Type, and select 2 as your Interval Value, the flow will execute every two weeks. This option is only available if the schedule type is set to Recurring.
Specifies the start date for the execution of the process flow.
Specifies the start time for the execution of the process flow.
Allows you to specify an end time for the execution of the process flow. This option is only available if the schedule type is set to Run Once or Multi-Day.
Specifies the end date for the execution of the process flow. This option is available if Specify End Date is selected.
Specifies the end time for the execution of the process flow. This option is available if Specify End Date is selected.
Specifies the day of the week on which the process flow will be executed. This option is only available if the schedule type is set to Recurring or Multi-Day.
Specifies the day of the month on which the process flow will be executed. This option is only available if the schedule type is set to Recurring or Multi-Day.
Specifies the beginning of the daily time span of the process flow. This option is only available if the schedule type is set to Recurring.
Specifies the end of the daily time span of the process flow. This option is only available if the schedule type is set to Recurring.
Specifies the option to execute the process flow on desired holidays.
The following options are available:
This option is only available if the schedule type is set to Recurring or Multi-Day.
This option controls where the log information from the Maintenance Job should be sent when the Job finishes.
The following options are available:
Multiple options can be selected. The default values for this option are ETLLOG and E-Mail.
Note: If the job is run from the DMC or Web Console, information will go to the console log regardless of this setting.
You can specify a list of dates that are designated as holidays in your company. These dates can be scheduled to be excluded, only included, or included to run with regular days in the process flow. To define a list of holidays, you must create a holiday file using a standard text editor and select the holiday file by issuing the SET command with the HDAY parameter.
For example: 20160315 Ides of March
In Windows and UNIX the file must be HDAYxxxx.err.
In OS/390, the file must be a member of ERRORS named HDAYxxxx, where xxxx is a string of text four characters long.
SET HDAY = xxxx
where:
Is the part of the name of the holiday file after HDAY. This string must be four characters long. For example, if your file name is hdaymyh1.err, then the setting will be SET HDAY = myh1.
Note: Alternatively, instead of the server profile, the setting can be saved in the user profile for the scheduler as set in sched_scan_id.
FILENAME=HDAYFILE, SUFFIX=FIX , DATASET=C:\ibi\srv77\dm\etc\hdaymyh1.err, $ SEGMENT=HDAYFILE, SEGTYPE=S0, $ FIELDNAME=HDAY_DATE, ALIAS=hddate, USAGE=YYMD, $ FIELDNAME=HDAY_DESC, ALIAS=hddesc, USAGE=A66, ACTUAL=A68, $
Note: DATASET should be set to your appropriate directory path.
WebFOCUS | |
Feedback |