Execute When

Execute When

OP TYPEWHENDESCRIPTION
Job Initialization
PREOncePerJobRuns 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 Preperation, Before Rows Get Processed
PREOnceBeforeConnRuns 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).
PREOnceBeforeQueryRuns 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.
PREOnceAfterConnRuns once per job when connections have been opened, and the origin query has been executed.
Job Running, Rows Being Proccessed
PRERepeatEachRowRuns once for each row, before any stages get executed.
PRERepeatEachStageRuns 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
POSTRepeatEachStageRuns 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.
POSTRepeatEachRowRuns once for each row after the mapping for all stages has been completed.
Row Processing Complete, Job Completing
POSTOnceBeforeConnRuns 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.
POSTOnceAfterConnRuns 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
POSTOncePerJobRuns 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

      Additional Documentation This Connector is based on the Sharepoint ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RSG/ado/ If connecting to Sharepoint using Single ...
    • 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 ...