Pt of the file containing log of a job
Moderators: chulett, rschirm, roy
Pt of the file containing log of a job
Hi All,
I want to know if the log we are getting in the DataStage Director for a job can be stored in a file or not.If Yes, where from we can get the file.
Thanks in advance
I want to know if the log we are getting in the DataStage Director for a job can be stored in a file or not.If Yes, where from we can get the file.
Thanks in advance
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: Pt of the file containing log of a job
bgs_vb wrote:Hi All,
I want to know if the log we are getting in the DataStage Director for a job can be stored in a file or not.If Yes, where from we can get the file.
Thanks in advance
I want some more information if there is a logpath for each and every project where the log file gets stored for each run of a job present in that project
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Logs are stored in tables in each Project repository named after the internal number associated with their parent job. There's no reason to go directly after those tables, however, as there is a perfectly good API for accessing that data.
From the DataStage side, open up the online help Index tab and go to the 'DSGet' section. There you'll find, amongst other things, the following functions used to get log information:
DSGetLogEntry
DSGetLogSummary
DSGetNewestLogId
If you prefer a scripted approach, there are dsjob equivalents to all of them and the same can be done from your favorite shell. Check the Command Line Interface section of either Designer Guide pdf for all the gory details on dsjob.
From the DataStage side, open up the online help Index tab and go to the 'DSGet' section. There you'll find, amongst other things, the following functions used to get log information:
DSGetLogEntry
DSGetLogSummary
DSGetNewestLogId
If you prefer a scripted approach, there are dsjob equivalents to all of them and the same can be done from your favorite shell. Check the Command Line Interface section of either Designer Guide pdf for all the gory details on dsjob.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I got the log of the job from the unix environment using dsjob -logsum command but it gives the entire log which we can see from the director.But I want the log of last run only.bart12872 wrote:Well, even if you copy the file containing the log, you won't be able to exploit it or read it. It is write in Basic Universe format.
What do you want to do more precisely.
Martin.
-
- Premium Member
- Posts: 278
- Joined: Wed Oct 03, 2007 8:45 am
Not sure if this will help =>
I have used an after job subroutine called DSJobReport found in job propertied that report start time, stop time, rows, etc.., There are 3 levels of reports that can be generated from this subroutine. In the input parms you specify the type of report - 1,2,3 and the output directory where the report file is written. Look in the Designer Client Guide PDF, chapter 4 under Before- and After-Job routines for how to use this feature. I do not know if this is available in V7.
I have used an after job subroutine called DSJobReport found in job propertied that report start time, stop time, rows, etc.., There are 3 levels of reports that can be generated from this subroutine. In the input parms you specify the type of report - 1,2,3 and the output directory where the report file is written. Look in the Designer Client Guide PDF, chapter 4 under Before- and After-Job routines for how to use this feature. I do not know if this is available in V7.