Run Job Options

Run Job Options

Definitions/explanations of the different options for when you wish to run a job.

Option Name
Description
Begin at Row
Begin at Row/Leave blank to start at the first row.
End at Row
End at Row/Leave blank to process through to the end of all rows.
Thread Count
Number of threads to spawn for processing data into the destination. Leave blank to use default. (set in StarfishEngine Web.config)
Argument
Allows user to pass in a run-time argument, which is available during the Job through the variable “@@VAR:JobArgument@@”. Job can pass a Return value out of the Job, through the VBScript Starfish Class property “ReturnValue”.
Logging Level - None
Only a total record count will be returned at the end of the Job.
Logging Level - Low
Returns an overview of each row/stage processed.
Logging Level - Medium
Returns Low Level messages, and displays all SQL statements that are executed.
Logging Level - High
Returns Low and Medium Level messages, and breaks down each field during evaluation. This shows the actual VBScript executed and return values from Function Fields.
Chain Jobs
If the current Job has Job Chaining enabled, this checkbox specified whether it should stop after this Job, or continue on following the daisy-chained jobs.
Notify on Complete
When the job is complete an email will be sent with a summary, including record counts and the log.





    • Related Articles

    • Starfish ETL iPaaS Logging Features and Settings

      Starfish ETL iPaaS Logging Features and SettingsStarfish ETL iPaaS has a number of options for logging and monitoring integration activity. Logging is required at various stages of the integration mapping process, during the testing phase prior to ...
    • Retrieve Records Modified After Last Run DateTime

      To only run data modified after the last time Starfish was run, we need to do two things: Set the last time Starfish ran. Filter the origin based on the last time Starfish ran. Set Last Run DateTime Create an After Operation Procedure and run the ...
    • Implementation Options

      Starfish Implementation Options StarfishETL On‐Prem – Install on your own server. Pro       Most secure option. Everything is behind the firewall       Data doesn’t leave your organization Con       If not implementing yourselves, you will need to ...
    • Use the same job to loop through multiple origins

      This example looks at reading from multiple mailboxes for email. Use a variable in the origin connection string. If the job needs to run for another mailbox, it calls the GotoJob function in the “Once After Conn” and pass in the Job's ID. Similar ...
    • Creating a New Job

      Jobs are a series of tasks that can be performed against a singe data source. Each Jobs may contain different Stages, which allow you to move the data to different destinations. You may have an unlimited number of Stages per Job, and an unlimited ...