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.
|
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 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.
|
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
|
PRE
|
OncePerJob
|
Runs once per job before execution ends. Will always be called, even if the job is ending due to error.
|