Execute When

Execute When

OP TYPE
WHEN
DESCRIPTION
Job Initialization
PRE
OncePerJob
Runs once per job before anything else get performed. Use this if you need to call GotoJob() and must first set up variables for your scripted loop. Will only be called once at the beginning of execution, even if GotoJob() is subsequently called.
Job Preparation, Before Rows Get Processed
PRE
OnceBeforeConn
Runs once per job when connections have not yet been opened – Use this to do things like download files, or modify your connection string in realtime. Will be called each time a job is executed (in the case where GotoJob() is called).
PRE
OnceBeforeQuery
Runs once per job when after db connections are open but before the origin query has been executed – Use this if you need to perform some kind of lookup on your database in order to build your origin query (or a portion of it) on the fly.
PRE
OnceAfterConn
Runs once per job when connections have been opened, and the origin query has been executed.
Job Running, Rows Being Proccessed
PRE
RepeatEachRow
Runs once for each row, before any stages get executed.
PRE
RepeatEachStage
Runs once for each stage in,your job, before the stage is executed - Use this in conjunction with custom stage flow control but just to set up variables for that stage – use CurrentStageName to evaluate which stage you're on within your code.
Row Stage Mapping Gets Executed Here
POST
RepeatEachStage
Runs once for each stage after the mapping for that stage has been processed, use this for custom stage flow control logic – use CurrentStageName to evaluate which stage you're on within your code.
POST
RepeatEachRow
Runs once for each row after the mapping for all stages has been completed.
POST
OnRowError
Special event which will be raised only if an error occurs while trying to process the current row. The error message is available to your script as a variable "ErrorMessage".
Row Processing Complete, Job Completing
POST
OnceBeforeConn
Runs once per job after all stages are complete but before your origin/destination connections have been closed – use this to execute any one-time cleanup code. Will not be executed if EndJob() is called or a job-end error occurs.
POST
OnceAfterConn
Runs once per job after the origin/destination connections have been closed – use this to set things like lastrundate. Will not be executed if EndJob() is called or a job-end error occurs.
Job Termination
POST
OncePerJob
Runs once per job before execution ends. Will always be called, even if the job is ending due to error.
    • Related Articles

    • Execute When

      OP TYPE WHEN DESCRIPTION Job Initialization PRE OncePerJob Runs once per job before anything else get performed. Use this if you need to call GotoJob() and must first set up variables for your scripted loop. Will only be called once at the beginning ...
    • Action Types

      The action type defines what type of operation will be performed. Variable-type actions create a user-defined variable for use throughout the job. Action Type Description Variable/SQL Set a variable through the execution of a SQL SELECT statement run ...
    • Table of Contents

      General Help Frequently Asked Questions Projects Renaming, Copying and Deleting Projects Renaming, Copying and Deleting Jobs Creating a Project Creating a New Job Jobs Create a New Job Renaming, Copying and Deleting Jobs Scheduling Jobs (IN PROGRESS) ...
    • Sharepoint Connector

      If connecting to Sharepoint using Single Sign-on (SSO) You might see this error if not connected appropriately - "[500] Could not execute the specified command: unrecognized response when getting SharePoint online security cookies, please check your ...
    • Sage 300 ERP Connector

      Overview Sage 300 versions supported: 2014 and higher.   It can read, write to the following tables (chart updated January 16, 2020) Sage 300 Entity Read Write Customer X X Contact 1 1 Products X Salesperson X Quote X X Order X X Invoice X X Payment ...