Use the Runtime Manager to manage projects and jobs, and to see an overview of your current scheduled tasks. Use the Runtime Manager scheduling wizard to manage scheduled tasks.
The Runtime Manager is based on the ETL Scheduler, which enables you to create, edit, delete, execute, list, import, and terminate scheduled tasks using a selected engine. Select the engine you want to use to manage your scheduled tasks from the Schedule Service drop-down list. A list of all tasks scheduled on that engine is displayed.
You can schedule tasks only on grid engines running
in the same subnet as ETL Development. To schedule tasks on grid
engines running in multiple subnets, run an instance of ETL Development
in the subnets in which these engines are running.
Select Tools | Runtime Manager.
Select Actions | Create. Alternatively, click the Create a New Schedule icon on the toolbar.
Select the project or job to execute. If required, select a parameter set or specify the Rep CDC Instance Name needed for incremental loading. Click Next.
Enter the schedule details:
Enter the schedule name, which must be unique.
Provide the start date and time for the schedule.
Click Repeat Task to specify how often you want the task to be repeated.
Click Advanced to specify:
Execute new task concurrently (default) – allows running multiple instances of the task concurrently.
Execute new task sequentially – waits for completion of the current process before executing the new one.
Do not execute new task – continues processing the current task and ignores the request to start a new task.
Cancel the running task before executing new task – stops the current process and starts the new one.
The “Stop the task after” option terminates a task that has been running for more than the specified duration. By default, this option is disabled.
Provide the end date, after which the schedule is inactivated.
Specify how often you want the task to be executed:
Daily – at a specified day interval.
Weekly – at a specified week interval.
Monthly – at a specified time on a particular day of each selected month. Specify the days of the month, and select the appropriate calendar months.
Once – only once at a specified date and time.
At engine startup – each time the engine starts.
Click Next.
If the schedule is successfully created, a message appears. Click Finish.
The new schedule appears in the Runtime Manager along with the existing schedules, if any.
Select the scheduled project or job to edit.
Click the Edit a Schedule icon on the toolbar, or select Actions | Edit. Alternatively, you can double-click the scheduled project or job to modify.
Select the scheduled project or job to execute.
Click the Execute a Schedule icon on the toolbar, or select Actions | Execute.
A scheduled task uses the same performance logging level
that has been set in the Preference window. To use a different log
level, change the “Performance Logging” option
before creating or editing the task, and then reset it after saving
the task. See“Collecting performance data”.
Select the scheduled project or job to delete.
Click the Delete a Schedule icon on the toolbar, or select Actions | Delete.
Setting refresh options for schedules
Select Actions | Enable Auto-Refresh to periodically update the schedule information. By default this option is not selected.
If Auto-Refresh is not enabled, the information displayed
may be old. Refresh the schedule manually to view the current status
of tasks.
Select Action | Refresh Interval to define the intervals at which you want the schedules to be updated. The refresh interval value should not be less than 2 seconds.
Click OK.
Importing tasks from the
Windows scheduler to ETL scheduler
You can import tasks previously scheduled on the Windows Scheduler to the ETL Scheduler.
From the Schedule Service drop-down list on the toolbar, select the target engine to which you want to import the Windows scheduled tasks.
Select Actions | Import.
Select the source engine from which to import the scheduled tasks and click OK. Windows scheduled tasks on the selected engine are imported to the ETL Scheduler.
Tasks are imported using the original name unless a task with the same name exists on the ETL Scheduler. If the current name already exists, you must provide a new name.
The name of the scheduled task must be unique.
Click Yes to delete the Windows schedule.
Click No, if you want to import the tasks from the source engine to any other engine before deleting them, or if you want to manually delete the tasks later, using the Windows Task Scheduler.
You see a message showing the result of the import. Click OK.
Select the scheduled project or job to terminate.
Click the Terminate a Running Schedule icon on the toolbar, or select Actions | Terminate.
