Execute When

From Starfish ETL
Jump to: navigation, search
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 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. 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.
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.