Managing jobs and scheduled tasks

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 create, edit, delete, execute, and terminate tasks.

Since Runtime Manager is based on the Windows task scheduling manager, it includes any scheduled ETL task currently defined on the system.

1. Select Tools | Runtime Manager.

2. Select Actions | Create. Alternatively, click the Create a new schedule icon on the toolbar.

3. Select the project or job you want to execute. Click Next.

4. Enter the schedule name. Provide the start time and the end date, and specify how often you want the task to be executed:

   • Daily – at a specified time everyday.

   • Weekly – at a specified time on particular days of every week. Specify the days of the week.

   • 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 Login – runs when you log in.

   • At System Startup – runs at system start-up.

   Click Next.

5. Enter the user name and password for the Windows user account that executes the schedule. Confirm the password. Click Next.

   The account information provided must be a valid Windows user account. The user must have read or write access to the ETL user folders such as the installation directory or the Windows user directory, depending on the type of installation.

6. If the schedule is successfully created, a message appears. Click Finish.

The new schedule will appear in the Runtime Manager along with the existing schedules, if any.

1. Select the scheduled project or job you want to edit.

2. Click the Edit a Schedule icon on the toolbar or select Edit from the Actions menu.

1. Select the scheduled project or job you want to execute.

2. Click the Execute a Schedule icon on the toolbar or select Execute from the Actions menu.

1. Select the scheduled project or job you want to delete.

2. Click the Delete a Schedule icon on the toolbar or select Delete from the Actions menu.

1. Select the scheduled project or job you want to terminate.

2. Click the Terminate a running Schedule icon on the toolbar or select Terminate from the Actions menu.

After a project or job is scheduled, they are executed under control of the Windows Task Scheduler.

Job execution state codes in the Task Scheduler are shown in the following table.