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.
|