Execute When
OP TYPE | WHEN | DESCRIPTION |
---|---|---|
JOB PREPERATION, 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 |
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,PROCESSED | ||
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 |
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 |
POST | OnceAfterConn | Runs once per job after the origin/destination connections have been closed – use this to set things like lastrundate |