How I can get a Report which lists the status of all Jobruns
Moderators: chulett, rschirm, roy
How I can get a Report which lists the status of all Jobruns
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.
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.
thanks & regards
kk
kk
Re: How I can get a Report which lists the status of all Job
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.
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.
-
- Premium Member
- Posts: 252
- Joined: Mon Sep 19, 2005 10:28 pm
- Location: Melbourne, Australia
- Contact:
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).
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).
Ross Leishman
I GOT THIS INFORAMTION BUT EXPLAIN IT ANY ONE KNOWS IT
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.
:: -----------------------------------------------------------------
:: 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.
thanks & regards
kk
kk
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
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).
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).
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
At present iam preparing this report manually it will takes 1 hr, butray.wurlod wrote: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. ...
i want to make a job for preparing the report. Is there anyway for this by using any subroutine...
thanks in Advance
thanks & regards
kk
kk
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
There are some who could be hired to construct one for a fee.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.4friends wrote:At present iam preparing this report manually it will takes 1 hr, butray.wurlod wrote: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. ...
i want to make a job for preparing the report. Is there anyway for this by using any subroutine...
thanks in Advance