Error in DSAttachJob to status other than "Finished&quo

kduke · Post by **kduke** » Fri Aug 25, 2006 4:18 pm

You should put code tags around your job listing so we can see the formatted code. This job gets the job status. It does nothing with the job log.

Why do you need this? What are you going to do with the sequential file?

DSguru2B · Post by **DSguru2B** » Fri Aug 25, 2006 5:20 pm

Need more info. What exactly do you want. Do you need the log files of all the jobs in a particular project, or you need particular info from log files for all the jobs? Plus you sure you want to collect the log files of all the jobs in a single sequential file. That file is going to be huge if you have 100 plus jobs.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 25, 2006 11:20 pm

You need to test explicitly for failure to attach jobs (clearly a job that has not been compiled will not have any run status) and bypass them. Any error in DSAttachJob returns an error code which is an integer less than zero.

Code: Select all

hJob = DSAttachJob(JobName, DSJ.ERRNONE)
JobName = DSGetJobInfo(hJob, DSJ.JOBNAME)
If JobName Matches "'-'1N0N"
Then
   * Failed to attach job
End
Else
   * Job attached OK
   * Process desired job information
   * Don't forget to detach job
   ErrCode = DSDetachJob(hJob)
End

Don't use PRINT statements - you'll never find the output. You need to use WriteSeq to write lines to a file.

wahil · Post by **wahil** » Mon Aug 28, 2006 10:06 am

I need list the log files of all the jobs in a particular project to a sequential file. This routine get job status and logs information too. This will be used to generate statistics about performance of jobs.

kduke · Post by **kduke** » Mon Aug 28, 2006 12:56 pm

Just download EtlStats from the links below my signature. That is what it is designed to do. It updates several tables. Just change it to update a sequential file. You need to modify the job GenHtmlJobLog to get the log file records. The job DSJobReportDbDriver runs the job DSJobReportDb which is the one you need to modify. DSJobReportDbDriver can be run for "all" jobs. Modify a couple jobs and you are done.

wahil · Post by **wahil** » Wed Sep 06, 2006 12:15 pm

Hi Kim,

I download EtlStats and its very good but in my company the environment is much "closed". We don't can use send mail, generate html routines, by example.
By this, i did create other jobs and use some routines yours.

The problem now is, who list jobs of other project in job control...

Any idea???

kduke · Post by **kduke** » Wed Sep 06, 2006 4:18 pm

EtlStats will not work across projects. So you need to install it in the other project.

dsjob can list all jobs in any project.

wahil · Post by **wahil** » Mon Sep 11, 2006 12:43 pm

[quote]EtlStats will not work across projects. So you need to install it in the other project.

dsjob can list all jobs in any project. [/quote]

Kim, ok to dsjobs. I'm tried to change function "GetLastRunLog" routine to work across projects, but the problem is in DSAttachJob function. This fine only to project logged...

The isJobMultipleInstance and GetJobCategory routines i am change and its run fine. I am add + one parameter(ProjName) and put the commands below in the top of the program.

[code]
Cmd = ''
Cmd := 'LOGTO ':aProjName
execute Cmd capturing output returning RtnCode
[/code]

kduke · Post by **kduke** » Mon Sep 11, 2006 1:42 pm

Did that work?

ray.wurlod · Post by **ray.wurlod** » Mon Sep 11, 2006 4:08 pm

LOGTO within programs is fraught with danger. For example, once you arrive in the new account (this works OK), which VOC file do you have open - that of the new account or that of the account from which you departed?

wahil · Post by **wahil** » Tue Sep 12, 2006 8:10 am

Ok Ray.

I will create all jobs and routines in all the projects(+/- 20)

.

Don't be very beautiful, but...

Ray and Kim, thanks a lot.

kduke · Post by **kduke** » Tue Sep 12, 2006 12:34 pm

You should pull out the jobs you do not need and just use the ones you do need. There are lots of jobs that are just to show you how to create metadata from system tables or from the DataStage repository. EtlStats has several jobs which are not used to get row counts. The same is true for the routines.