Execute When: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 3: | Line 3: | ||
! WHEN | ! WHEN | ||
! DESCRIPTION | ! DESCRIPTION | ||
|- style="background-color:#ffffcc; font-weight: bold;" | |||
| colspan="3" | 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. | |||
|- style="background-color:#ffffcc; font-weight: bold;" | |- style="background-color:#ffffcc; font-weight: bold;" | ||
| colspan="3" | Job Preperation, Before Rows Get Processed | | colspan="3" | Job Preperation, Before Rows Get Processed | ||
Line 42: | Line 48: | ||
| POST | | POST | ||
| OnceBeforeConn | | 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. | | 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 | | POST | ||
| OnceAfterConn | | OnceAfterConn | ||
| Runs once per job after the origin/destination connections have been closed – use this to set things like lastrundate. | | 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. | ||
|- style="background-color:#ffffcc; font-weight: bold;" | |||
| colspan="3" | Job Termination | |||
|- | |||
| PRE | |||
| OncePerJob | |||
| Runs once per job before execution ends. Will always be called, even if the job is ending due to error. | |||
|} | |} |
Revision as of 15:45, 17 May 2018
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. |