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 Connect Creatio 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
StarfishETL iPaaS Logging Features and Settings
StarfishETL iPaaS Logging Features and Settings StarfishETL 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
StarfishETL 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 ...