|
Collapse All | Expand All | Show Default |
| SeqPrepareEtlStats
DataStage Job Report Generated 2005-02-15 08:26:49pm |
| - Job Design |
|
|---|
| - Job Information |
| - Job Properties (7) |
| Property | Value |
| Object Type | sequencer |
| Short Description | kduke 2004-06-03 created |
| Full Description | Job: SeqPrepareEtlStats
================================================================= Description: Sequence to load all EtlStat lookups. ================================================================= Parameters: 1. FilePath 2. SourceDSN 3. SourceUser 4. SourcePwd 5. TargetDSN 6. TargetPwd 7. TargetUser ================================================================= Jobs: ExtractJobStatusSeq BuildJobStatusHash ================================================================= Modification History ================================================================= Developer Date Modification description ======== ========= ============================================== kduke 2004-06-03 created ======== ========= ============================================== |
| Category | EtlStats |
| Multiple Instance | False |
| Job Version Number | 40.1.1 |
| Hash File Cache Sharing | False |
| - Parameters (7) |
| Parameter Name | Prompt | Default Value | Help Text |
| SourceDSN | SourceDSN | kduke | |
| SourceUser | SourceUser | etluser | |
| SourcePwd | SourcePwd | LDH@9:VA=93L0O5I<;J| |
|
| TargetDSN | TargetDSN | kduke | |
| TargetUser | TargetUser | etluser | |
| TargetPwd | TargetPwd | LDH@9:VA=93L0O5I<;J| |
|
| FilePath | FilePath | ./ |
| - Stages (11) |
| - Source Stages (3) |
| ExtractJobStatusSeq (job) |
| LoadEtlJobLink (job) |
| SeqExceptionHandler (exception) |
| - Processing Stages (6) |
| BuildJobStatusHash (job) |
| LoadEtlJob2 (job) |
| LoadEtlJob (job) |
| WaitAll (sequencer) |
| FailureNotification (notification) |
| DSJobReportDbDriver (job) |
| - Target Stages (2) |
| Done (sequencer) |
| SeqAbortedtoLog (routine) |
| - Source Stages (3) |
| - ExtractJobStatusSeq (job) |
| - Stage Properties (3) |
| Property | Value |
| Job Name | ExtractJobStatusSeq |
| Short Description | kduke 2004-06-03 created |
| Full Description | Job: ExtractJobStatusSeq
================================================================= Description: Generic job to build job status. ================================================================= Parameters: none used ================================================================= Sources: internal to code ================================================================= Targets: JobStatusStg.txt ================================================================= To use in next job: BuildJobStatusHash ================================================================= Modification History ================================================================= Developer Date Modification description ======== ========= ============================================== kduke 2004-06-03 created ======== ========= ============================================== |
| - Parameters (1) |
| Parameter Name | Value |
| FilePath | FilePath |
| - Output Links (1) |
| OkStat1 triggers BuildJobStatusHash when the job finishes OK |
| - LoadEtlJobLink (job) |
| - Stage Properties (3) |
| Property | Value |
| Job Name | LoadEtlJobLink |
| Short Description | Last Changed: 07-29-2004 |
| Full Description | Job: LoadEtlJobLink
------------------------------------------------------------------------------------- Non-technical description: Load link names from DS_JOBOBJECTS. ------------------------------------------------------------------------------------- Business rules: Runs from SqlPrepareStats. ------------------------------------------------------------------------------------- Rules for restarting this job: Just rerun. ------------------------------------------------------------------------------------- Parameters: 1. TargetDSN 2. TargetUser 3. TargetPwd ------------------------------------------------------------------------------------- Sources: DS_JOBOBJECTS ------------------------------------------------------------------------------------- Targets: ETL_JOB_LINK ------------------------------------------------------------------------------------- Modification History: ------------------------------------------------------------------------------------- UserId Date Version Modification Description ------------------------------------------------------------------------------------- kduke 07-29-2004 1 Created job. ------------------------------------------------------------------------------------- |
| - Parameters (3) |
| Parameter Name | Value |
| TargetDSN | TargetDSN |
| TargetUser | TargetUser |
| TargetPwd | TargetPwd |
| - Output Links (1) |
| OkJob1 triggers LoadEtlJob2 when the job finishes OK |
| - SeqExceptionHandler (exception) |
| - Processing Stages (6) |
| - BuildJobStatusHash (job) |
| - Stage Properties (3) |
| Property | Value |
| Job Name | BuildJobStatusHash |
| Short Description | kduke 2004-06-03 created |
| Full Description | Job: BuildJobStatusHash
================================================================= Description: Generic job to build job status used as lookup in job DSJobReportDb. ================================================================= Parameters: 1. FilePath ================================================================= Sources: JobStatusSeq.txt ================================================================= Targets: JobStatusHash ================================================================= To use in next job: DSJobReport... jobs several. ================================================================= Modification History ================================================================= Developer Date Modification description ======== ========= ============================================== kduke 2004-06-03 created ======== ========= ============================================== |
| - Parameters (1) |
| Parameter Name | Value |
| FilePath | FilePath |
| - Input Links (1) |
| OkStat1 triggered by ExtractJobStatusSeq |
| - Output Links (1) |
| OkStat2 triggers WaitAll when the job finishes OK |
| - LoadEtlJob2 (job) |
| - Stage Properties (3) |
| Property | Value |
| Job Name | LoadEtlJob2 |
| Short Description | Last Changed: 07-29-2004 |
| Full Description | Job: LoadEtlJob2
------------------------------------------------------------------------------------- Non-technical description: Load ETL_JOB with job category. ------------------------------------------------------------------------------------- Business rules: Runs from SeqPrepareEtlStats. ------------------------------------------------------------------------------------- Rules for restarting this job: Just rerun. ------------------------------------------------------------------------------------- Parameters: None ------------------------------------------------------------------------------------- Sources: tbd ------------------------------------------------------------------------------------- Targets: tbd ------------------------------------------------------------------------------------- Modification History: ------------------------------------------------------------------------------------- UserId Date Version Modification Description ------------------------------------------------------------------------------------- kduke 07-29-2004 1 Created job. ------------------------------------------------------------------------------------- |
| - Parameters (3) |
| Parameter Name | Value |
| TargetDSN | TargetDSN |
| TargetUser | TargetUser |
| TargetPwd | TargetPwd |
| - Input Links (1) |
| OkJob1 triggered by LoadEtlJobLink |
| - Output Links (1) |
| OkJob2 triggers LoadEtlJob when the job finishes OK |
| - LoadEtlJob (job) |
| - Stage Properties (3) |
| Property | Value |
| Job Name | LoadEtlJob |
| Short Description | Last Changed: 07-29-2004 |
| Full Description | Job: LoadEtlJob
------------------------------------------------------------------------------------- Non-technical description: Load ETL_JOB to use in reports to pull in job category. ------------------------------------------------------------------------------------- Business rules: Runs from SeqPrepareEtlStats. ------------------------------------------------------------------------------------- Rules for restarting this job: Just rerun. ------------------------------------------------------------------------------------- Parameters: 1. TargetDSN 2. TargetUser 3. TargetPwd ------------------------------------------------------------------------------------- Sources: ETL_JOB_HIST ------------------------------------------------------------------------------------- Targets: ETL_JOB ------------------------------------------------------------------------------------- Modification History: ------------------------------------------------------------------------------------- UserId Date Version Modification Description ------------------------------------------------------------------------------------- kduke 07-29-2004 1 Created job. ------------------------------------------------------------------------------------- |
| - Parameters (3) |
| Parameter Name | Value |
| TargetDSN | TargetDSN |
| TargetUser | TargetUser |
| TargetPwd | TargetPwd |
| - Input Links (1) |
| OkJob2 triggered by LoadEtlJob2 |
| - Output Links (1) |
| OkJob3 triggers WaitAll when the job finishes OK |
| - WaitAll (sequencer) |
| - Stage Properties (1) |
| Property | Value |
| Wait for | All |
| - Input Links (2) |
| - Output Links (1) |
| OkAll triggers DSJobReportDbDriver unconditionally |
| - FailureNotification (notification) |
| - Stage Properties (4) |
| Property | Value |
| Server | localhost |
| To | kim_duke-cw@discovery.com |
| From | kim_duke-cw@discovery.com |
| Subject | SeqPrepareEtlStats Sequence failed |
| - Input Links (1) |
| ToFailureNotification triggered by SeqExceptionHandler |
| - Output Links (1) |
| ToSeqAborted triggers SeqAbortedtoLog unconditionally |
| - DSJobReportDbDriver (job) |
| - Stage Properties (3) |
| Property | Value |
| Job Name | DSJobReportDbDriver |
| Short Description | kduke 2004-06-03 created |
| Full Description | Job: DSJobReportDbDriver
================================================================= Description: This job will get row counts for all jobs in a sequence. ================================================================= Parameters: 1. TargetDSN 2. TargetPwd 3. TargetUser 4. SeqName - Job sequence 5. EmailFlag 6. CheckParentFlag 7. EmailTo 8. DebugSw ================================================================= Sources: none ================================================================= Targets: none ================================================================= To use in next job: DSJobReportDbDriver ================================================================= Modification History ================================================================= Developer Date Modification description ======== ========= ============================================== kduke 2004-06-03 created ======== ========= ============================================== |
| - Parameters (10) |
| Parameter Name | Value |
| TargetDSN | TargetDSN |
| TargetUser | TargetUser |
| TargetPwd | TargetPwd |
| SeqName | "SeqPrepareEtlStats" |
| EmailFlag | "1" |
| CheckParentFlag | "0" |
| EmailTo | "Kim" |
| DebugSw | "0" |
| FilePath | "./" |
| LogoPath | "OurLogo.jpg" |
| - Input Links (1) |
| OkAll triggered by WaitAll |
| - Output Links (1) |
| Ok3 triggers Done unconditionally |
| - Target Stages (2) |
| - Done (sequencer) |
| - Stage Properties (1) |
| Property | Value |
| Wait for | All |
| - Input Links (1) |
| Ok3 triggered by DSJobReportDbDriver |
| - SeqAbortedtoLog (routine) |
| - Stage Properties (3) |
| Property | Value |
| Routine Name | UtilityAbortToLog |
| Short Description | Abort the job with a user-supplied log message |
| Full Description | This routine takes a user defined message and displays it in the log as a fatal error message.
The routine should not be used in production. It should be used as a means to stop processing in job development, based on error conditions such as a threshold violation. The return value of this function is always -1. Note that DSGetJobInfo, DSGetLinkInfo and DSGetStageInfo are called as macros (defined in Jobcontrol.h) to get the names of the job, name and link calling this function. This is used to further quallify the message string in the log. |
| - Parameters (1) |
| Parameter Name | Value |
| Arg1 | "SeqPrepareEtlStats Aborted." |
| - Input Links (1) |
| ToSeqAborted triggered by FailureNotification |
