Creating Jobs

To create a job, you can right-click the Jobs entry in the Navigator section and select New | Job from the pop-up menu. The available job components are displayed in the Component Store.

StepsTo create a job with minimum components

  1. Add the Start component from the Component Store to the Design section.

  2. Add the Project component and connect it to the Start component.

  3. Add the Finish component and connect it to the Project component.

  4. Double-click on the Project component to open the project browser window.

  5. Select the project you want to make part of this job.

  6. Close and save the job. The job is now ready to be executed in the Sybase IQ ETL Development desktop or as a scheduled task.

From the Navigator section, you can directly display and access the projects included in a job by opening the sub-branch.

Modifying a job

Double-click the job name in the Navigator section or select Open from the pop-up menu.

Copying a job

To copy a job to a specified destination, open it and select Save As from the File menu.

NoteYou can copy a job into a different repository only when working with multiple repositories.

Deleting a job

StepsTo delete a job

  1. Right-click the job in the Navigator.

  2. Select Delete from the pop-up menu. The Confirm Job Delete dialog box appears.

  3. Click Delete. By default, only the job is deleted. You can also delete the job and all included projects by selecting the Delete Included Projects check box and then clicking Delete.

NoteWhen using this option, be sure that related projects are not used in other jobs as well, because this is not checked automatically. Projects that are currently open for design (locked by any user) are not affected.

Renaming a job

Highlight the job listed in the Navigation tree, right-click, and select Rename.

Scheduling a job

StepsTo send a job to the Task Scheduler

  1. Open the job.

  2. Click the Start component.

  3. In the Property section, click Edit Schedule Job of the Start Time property.

  4. Enter the task parameters as described in the Runtime Manager section.

Controlling job execution

Job execution can be controlled as follows:

Refer to “Job components” for more detail about job configuration.