Property	Value
Object Type	Server
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 ======== ========= ==============================================
Category	EtlStats
Multiple Instance	False
Job Version Number	40.1.1
Hash File Cache Sharing	False
Job Control	* ================================================================= * Job: ExtractJobStatusSeq * ================================================================= * Description: * Generic job to build job status. * ================================================================= * Created by: Kim Duke June 6, 2004 * ================================================================= JobName = "ExtractJobStatusSeq" SeqFileName = "JobStatusHash" SeqFileName = FilePath : "Staging/JobStatusStg.txt" openseq SeqFileName to SeqFilePtr else * ================================================================= * create table if it does not exist * ================================================================= If Status() <> 0 Then Call DSLogFatal("Error: Unable to open " : SeqFileName, JobName) goto TheEnd End end * Possible return values for token DSJ.STATUS: * Equ DSJS.RUNNING To 0 ;* This is the only status that means the job is actually running * Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no warnings * Equ DSJS.RUNWARN To 2 ;* Job finished a normal run with warnings * Equ DSJS.RUNFAILED To 3 ;* Job finished a normal run with a fatal error * Equ DSJS.VALOK To 11 ;* Job finished a validation run with no warnings * Equ DSJS.VALWARN To 12 ;* Job finished a validation run with warnings * Equ DSJS.VALFAILED To 13 ;* Job failed a validation run * Equ DSJS.RESET To 21 ;* Job finished a reset run * Equ DSJS.CRASHED To 96 ;* Job has crashed * Equ DSJS.STOPPED To 97 ;* Job was stopped by operator intervention (can't tell run type) * Equ DSJS.NOTRUNNABLE To 98 ;* Job has not been compiled * Equ DSJS.NOTRUNNING To 99 ;* Any other status Rec = '' Rec<1, 1> = 0 Rec<2, 1> = 'Running' Rec<1, 2> = 1 Rec<2, 2> = 'Finished' Rec<1, 3> = 2 Rec<2, 3> = 'Finished (see log)' Rec<1, 4> = 3 Rec<2, 4> = 'Aborted' Rec<1, 5> = 7 Rec<2, 5> = 'Validated OK' Rec<1, 6> = 8 Rec<2, 6> = 'Failed validation' Rec<1, 7> = 9 Rec<2, 7> = 'Has been reset' Rec<1, 8> = 11 Rec<2, 8> = 'Validated OK' Rec<1, 9> = 12 Rec<2, 9> = 'Validated (see log)' Rec<1,10> = 13 Rec<2,10> = 'Failed validation' Rec<1,11> = 21 Rec<2,11> = 'Has been reset' Rec<1,12> = 96 Rec<2,12> = 'Aborted' Rec<1,13> = 97 Rec<2,13> = 'Stopped' Rec<1,14> = 98 Rec<2,14> = 'Not Compiled' Rec<1,15> = 99 Rec<2,15> = 'Compiled' NoOfStatuses = dcount(Rec<1>, @VM) * NoOfStatuses = 15 for i=1 to NoOfStatuses SeqRec = Rec<1, i> SeqRec := ',"': Rec<2, i>:'"' Call DSLogInfo(SeqRec, JobName : " JobControl") writeseq SeqRec on SeqFilePtr else Call DSLogFatal("Error: Unable to write to " : SeqFileName, JobName) goto TheEnd end next i weofseq SeqFilePtr Call DSLogInfo(NoOfStatuses :" rows written to ":SeqFileName, JobName : " JobControl") * ================================================================= * exit program here * ================================================================= TheEnd:

Parameter Name	Prompt	Default Value	Help Text
FilePath	FilePath	./

- Source Stages (0)  + Source Stages (0)

- Processing Stages (0)  + Processing Stages (0)

- Target Stages (0)  + Target Stages (0)