Back to Index |

Job Sequence objects overview

When you create a new Job Sequence, you will have access to the objects under the Job Sequence toolbar. These objects, as well as the Process Objects can be used to design and develop a job sequence to run an entire process.

Below is an overview of the job sequence specific objects. Click each of the icons to see more detailed information for that particular object.

Object | Description
More... | Run Job: This object allows you to run a BlueSky Integration Studio job. You can run an ETL job design (extraction, transformation, load) or another sequence job. The Run Job object also gives you the capability of running the job and waiting for it to complete before continuing on, or you can run a job and immediately jump to the next step in the sequence (WaitType=RunNoWait). To use this object, simply drag it onto the Job Sequence design window, click the SelectJob property ellipse button and select the job to run.
More... | Wait for Jobs: This object is used to wait for 'x' number of jobs to complete before continuing on with the job sequence. For instance; say you want to run 2 jobs in parallel, but wait for both of them to complete. You would have 2 job objects, both with the WaitType set to RunNoWait, then have the Wait for Jobs object next in the sequence with its SelectedJobs property set to Job 1 and Job 2.
More... | Status Report: The Status Report is a simple object that will generate a text-based report (similar to what you see in the job control window) of all of the jobs in the system, showing their current status, start and end times, etc... which you can set to e-mail to someone via SMTP.
| Boolean IF block objects: The IF objects allows you to write some VB.NET code, returning True or False, to specify whether or not the Job Sequence should perform a particular set of actions. Each IF block must begin with the IF object and end with the End If object. For instance; maybe you have a separate process that runs during the week vs. during the weekend. You could build something like this:
More...
| Folder Watch object: Suppose you need to process 'x' number of files in the same format. With the Folder Watch object, you could have those files dumped into a folder on the server, then loop around and process all of them in a single job. The Folder Watch object works with the Loop object to watch a folder for incoming files, process them, and loop back around to look for more files.
More...
| Stop object: This object notifies the job sequence to stop processing

© 2003 - 2007 Relational Solutions, Inc. - All rights reserved