Back to Index |

Job Sequence

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.

Run Job and Parameters: If the job you are calling has parameters, they will automatically be imported into the job sequence. This allows the job sequence to forward the parameter values on to the job(s) that are being executed from within the job sequence.

Properties

Alias | Alias identifier. Aliases are used on all design objects to simplify coding and to ensure each object has a unique identifier.
Comments | Comment area to give descriptive text about the object and its purpose.
SelectJob | Clicking the ellipse button on this property will allow you to select a BlueSky Integration Studio job to run. Simply select the job to run and click OK. Doing so will automatically fill in all of the necessary properties to properly configure the sequence job to run the specified job. You will notice there are a few properties that are not editable such as ApplicationDomain, ApplicationDomainPath, JobName and RelativePath. These are the properties that specify where the job is in the repository. They are simply reference pointers to the job.
OnJobAbort | The OnJobAbort property gives you the control to specify whether or not you want the Sequence Job to Abort or Continue on if the job that was called happens to Abort. Possible values are AbortJob and ContinueOn
WaitType | Default: RunWait. The WaitType property specifies how to run the job. RunWait: The job will be executed and the sequence job will wait until it completes before continuing on to the next object in the sequence. RunNoWait: The job will be executed and the sequence job will NOT wait, it will immediately continue on to the next object in the sequence. You can use this property to run several jobs in parallel. For instance; if you have 3 jobs, all with a WaitType of RunNoWait, the 3 jobs will be executed together and they will all run at the same time in parallel.
NotifyOnAbort | The NotifyOnAbort and NotifyOnCompletion properties allow you to e-mail someone for each one of these events. For instance; if you have a critical nightly process that runs and you need to be notified if the job aborts. Most cell phone and text pagers today also have a corresponding email address which makes it easy to also send a page message.
NotifyOnCompletion
Name | Descriptive name for this object. You can enter any text to describe the object. When a job is selected, this property is set to the job name if it has not already been set by the developer.

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