|
Collapse All | Expand All | Show Default |
| SeqJobStatus
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: SeqJobStatus
================================================================= Description: Sequence to load JobStatusHash. ================================================================= 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.0.0 |
| 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 (7) |
| - Source Stages (2) |
| ExtractJobStatusSeq (job) |
| SeqExceptionHandler (exception) |
| - Processing Stages (3) |
| BuildJobStatusHash (job) |
| FailureNotification (notification) |
| DSJobReportDbDriver (job) |
| - Target Stages (2) |
| Done (sequencer) |
| SeqAbortedtoLog (routine) |
| - Source Stages (2) |
| - 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) |
| Ok1 triggers BuildJobStatusHash when the job finishes OK |
| - SeqExceptionHandler (exception) |
| - Processing Stages (3) |
| - 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) |
| Ok1 triggered by ExtractJobStatusSeq |
| - Output Links (1) |
| Ok2 triggers DSJobReportDbDriver when the job finishes OK |
| - FailureNotification (notification) |
| - Stage Properties (4) |
| Property | Value |
| Server | localhost |
| To | kim_duke-cw@discovery.com |
| From | kim_duke-cw@discovery.com |
| Subject | Time 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 (4) |
| Parameter Name | Value |
| TargetDSN | TargetDSN |
| TargetUser | TargetUser |
| TargetPwd | TargetPwd |
| SeqName | "SeqJobStatus" |
| - Input Links (1) |
| Ok2 triggered by BuildJobStatusHash |
| - Output Links (1) |
| Ok3 triggers Done when the job finishes OK |
| - 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 | "SeqJobStatus Aborted." |
| - Input Links (1) |
| ToSeqAborted triggered by FailureNotification |
