How I can get a Report which lists the status of all Jobruns

[4friends]

Hi,

How I can Get a Report of all job ran succesfully, Job start time, end time and elapsed time and no of rows procesed from eack links(insert/update) or any aborts if occurs.

Thanks.

[sachin1]

hello,

i think you need to write a custom routine which needs to be used in "After-job Subroutine"(Job properties), which will track your job status and write an information in log file.


Main function to be used is DSGetJobInfo with InfoType=DSJ.JOBINTERIMSTATUS.

DSJ.JOBINTERIMSTATUS. Returns the status of a job after it has run all stages and controlled jobs, but before it
has attempted to run an after-job subroutine. (Designed to be used by an after-job
subroutine to get the status of the current job)

get some more information on DSGetJobInfo which will help you.

[rleishman]

There are probably a couple of ways, but all of them are a bit tricky.

From DataStage shell ($DSHOME/bin/dssh) you could write a SQL that joins the appropriate tables. That would require a detailed knowlege of the unpublished UniVerse table structure and an even more detailed knowlege of UniVerse. I wouldn't try it.

The way I woud do it is to write a Server Routine. If you have a look at the Datastage BASIC manual that was distributed with your software, you will find functions such as DSGetProjectInfo(), which will obtain a list of all jobs, DSAttachJob and DSGetJobInfo(), which will attach to a named job and obtain a list of all stages in a job, and DSGetLinkInfo(), which will get link counts for each link on a stage.

That will get you started. Look at the doco and search this site for examples of those functions and decide whether it's something you want to go ahead with (cos its not simple).

[4friends]

Before the job reports can be generated change the hard coded values in the DSaveAsBitmap.bat file:


:: -----------------------------------------------------------------

:: Hard-coded values. Dependent on each computer.

:: -----------------------------------------------------------------

SET Designer=C:\Progra~1\Ascential\DataStage\dsdesign.exe

SET DsJob=C:\Progra~1\Ascential\DataStage\dsjob.exe

SET JobList=JobList.txt

SET ProjectList=ProjectList.txt

SET DSLog=DSaveAsBmpLog

SET BackupDir=c:\DataStage\KimD\Jobs\%Project%

Next change the hard coded host, login, password and project details in the DSaveAsBmpDriver.bat driver batch file:


DSaveAsBmp.bat MyHost MyUser MyPwd MyProject

Import the KgdGenHtml.dsx file into your DataStage project and set the job parameters to suit your environment.

Compile all jobs and run SeqGenAllHtml:

SEQUENCE ---------> SEQUENCE ----------> SEQUENCER
Ok1 Ok2
KgdGenHtmlJobDocs KgdGenHtmlRoutineDocs Done


The SeqGenAllHtml will call two routines, JobDocs and RoutineDocs. It will write the html pages to the directory specified in the job parameters and embed a link to a bitmap.

When you run the DSaveAsBitmapDriver.bat it will create the bitmap files for each job in the project.

[4friends]

I got this above inforamtion but iam not understand to this please explain it

Thanks in Advance...

[ray.wurlod]

Why do you specify "without using Director"? It's by far the easiest way.

The status of each and every job is in a separate table in the Repository.

[throbinson]

I would suppose he has 1000's of jobs and wants a "dashboard" type report to monitor the health of his system at any given point in time
at the Project level. Seeing this type of metadata in Director is easiest but completely unworkable for this type of reporting. I'm guessing he wants it at the Project level. (As do we).

[ray.wurlod]

Go to Status view.
Disable display of Categories in the View menu.
Optionally sort by Status. Or sort by job name.
Print your report.
Re-enable display of Categories.

[4friends]

Why do you specify "without using Director"? It's by far the easiest way.

The status of each and every job is in a separate table in the Repository. ...

At present iam preparing this report manually it will takes 1 hr, but
i want to make a job for preparing the report. Is there anyway for this by using any subroutine...

thanks in Advance

[ray.wurlod]

Of course there is. But the routine does not ship with the product.

There are some who could be hired to construct one for a fee.

[baigdw]

Why do you specify "without using Director"? It's by far the easiest way.

The status of each and every job is in a separate table in the Repository. ...

At present iam preparing this report manually it will takes 1 hr, but
i want to make a job for preparing the report. Is there anyway for this by using any subroutine...

thanks in Advance

The process mentioned by Ray would be the best if you need to generated the report manually. It takes 5 min at max. I had generated reports earlier and used macros in Ultraedit to edit the file before publishing it for reporting purposes. The whole process took me about 15 min.

[kduke]

Search for EtlStats.