User`s guide

Managing jobs
36 Sybase IQ ETL 4.1
If you have multiple data streams it is highly advisable to design a project for
each data stream so that all components within a project are connected to each
other. By following this design guideline, it is easy control the data streams by
connecting the projects to form a job process flow.
Managing jobs
A job lets you easily set up the powerful control flows for one or multiple
projects. Although Sybase IQ ETL projects require some kind of user
interaction during simulation or execution, a Sybase IQ ETL job can be
scheduled to run without any user interaction.
Depending on the success or failure of a project within a job, you can control
the job execution.
Job components
A job consists at least one of the following components:
• A Start component
• A Project component
• A Success component
Figure 4-2 shows an example of a job with one Start component, one Project
component, and one Success component.
Figure 4-2: A Job with the minimum components
A job can be extended to include:
• Multiple projects in sequential or parallel order
• Multiple synchronizers
• Multiple Success and Error components