Execute When: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(2 intermediate revisions by 2 users not shown) | |||
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. Will only be called once at the beginning of execution, even if GotoJob() is subsequently called. | |||
|- 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 8: | Line 14: | ||
| PRE | | PRE | ||
| OnceBeforeConn | | OnceBeforeConn | ||
| Runs once per job when connections have not yet | | 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). | ||
been opened – | |||
connection string in realtime | |||
|- | |- | ||
| PRE | | PRE | ||
| OnceBeforeQuery | | OnceBeforeQuery | ||
| Runs once per job when after db connections are | | 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. | ||
open but before the origin query has been executed – | |||
perform some kind of lookup on your database in order to build your origin | |||
query (or a portion of it) on the fly | |||
|- | |- | ||
| PRE | | PRE | ||
| OnceAfterConn | | OnceAfterConn | ||
| Runs once per job when connections have been | | Runs once per job when connections have been opened, and the origin query has been executed. | ||
opened, and the origin query has been executed | |||
|- style="background-color:#ffffcc; font-weight: bold;" | |- style="background-color:#ffffcc; font-weight: bold;" | ||
| colspan="3" | Job Running, Rows Being Proccessed | | colspan="3" | Job Running, Rows Being Proccessed | ||
Line 28: | Line 28: | ||
| PRE | | PRE | ||
| RepeatEachRow | | RepeatEachRow | ||
| Runs once for each row, before any stages get | | Runs once for each row, before any stages get executed. | ||
executed | |||
|- | |- | ||
| PRE | | PRE | ||
| RepeatEachStage | | RepeatEachStage | ||
| Runs once for each stage in,your job, before the stage is executed | | 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. | ||
|- style="background-color:#ffffcc; font-weight: bold;" | |- style="background-color:#ffffcc; font-weight: bold;" | ||
| colspan="3" | Row Stage Mapping Gets Executed Here | | colspan="3" | Row Stage Mapping Gets Executed Here | ||
Line 39: | Line 38: | ||
| POST | | POST | ||
| RepeatEachStage | | RepeatEachStage | ||
| Runs once for each stage after | | 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 | | POST | ||
| RepeatEachRow | | RepeatEachRow | ||
| Runs once for each row after | | Runs once for each row after the mapping for all stages has been completed. | ||
|- style="background-color:#ffffcc; font-weight: bold;" | |- style="background-color:#ffffcc; font-weight: bold;" | ||
| colspan="3" | Row Processing Complete, Job Completing | | colspan="3" | Row Processing Complete, Job Completing | ||
Line 49: | Line 48: | ||
| POST | | POST | ||
| OnceBeforeConn | | OnceBeforeConn | ||
| Runs once per job after all | | 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 | | 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. | |||
|} | |} |
Latest revision as of 15:46, 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. 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. |