Can we export joblog to a file

chitravallivenkat · Post by **chitravallivenkat** » Tue Apr 17, 2007 10:37 pm

Hi All,

Can we export/save the joblog or job status to a file??

I want to use that file in some other application so that i can derive the elapsed time of the job and other details.

I just want to take the information about the job out of DataStage application...

Please reply... Thanks in Adv..

Regards

VC

priyadarshikunal · Post by **priyadarshikunal** » Tue Apr 17, 2007 11:43 pm

chitravallivenkat wrote:Hi All,

Can we export/save the joblog or job status to a file??

I want to use that file in some other application so that i can derive the elapsed time of the job and other details.

I just want to take the information about the job out of DataStage application...

Please reply... Thanks in Adv..

Regards

VC

I think u can use API function DSGetLogEntry to retrive log details and then redirect it to a file

ray.wurlod · Post by **ray.wurlod** » Wed Apr 18, 2007 12:09 am

You can use the Print dialog from Director (check Print To File).
You can create a DataStage job to do it.
You can create a routine using the DataStage API - depending on what you want you may need various of the DSGetLog... functions.

However, it's probable that most of the details you require are accessible from the API without accessing the log. Research the other DSGet...Info functions.

rkdatastage · Post by **rkdatastage** » Fri Apr 20, 2007 12:15 am

Hi Priya

Can you give some input on writing a code step by step to store the log details into a file.

thanks in advance
RK

ray.wurlod · Post by **ray.wurlod** » Fri Apr 20, 2007 12:25 am

Most of what you need is here - doesn't your Search button work?

chitravallivenkat · Post by **chitravallivenkat** » Fri Apr 20, 2007 3:57 am

Thanks Ray..

I have used the Print to file option...

VC

chulett · Post by **chulett** » Fri Apr 20, 2007 6:54 am

Wow... I thought Ray only ever threw that out there as a teaser.

Only time I use it is to create artifacts for Support - "send me the job log". Otherwise, one typically seeks a more automated solution. Glad that worked for you.

jeawin · Post by **jeawin** » Wed Apr 25, 2007 2:03 am

I have written two DataStage jobs that reproduce the Director log, and also the same details as shown in the Monitor window. Both of these are saved to CSV files on the Server. The files can then be FTP'd or whatever onto your PC.

Here are examples of the output:

Let me know if you would like a copy of the jobs.

rafik2k · Post by **rafik2k** » Wed Apr 25, 2007 5:00 am

jeawin
Is your job automated for every job for a project?

Can you please share logic of your job

DSguru2B · Post by **DSguru2B** » Wed Apr 25, 2007 7:28 am

The images are not showing up.

raewu · Post by **raewu** » Wed Apr 25, 2007 8:03 am

that's a great tool you've made there

DSguru2B · Post by **DSguru2B** » Wed Apr 25, 2007 8:05 am

Never mind, its blocked on our intranet. Ill check it out at home. Disregard my previous post.

jeawin · Post by **jeawin** » Wed Apr 25, 2007 8:08 am

No, the jobs are not automated, though can obviously be scheduled.

The Metrics job has the following parameters:
CATEGORY: Enter one or more categories here
PATH: Full path name to output csv file directory
FNAME: Output CSV file name

The Monitor Details job has the following parameters:
CATEGORY: EITHER: for report on one or more categories, enter them here
JOBNAME: OR: for report on single job only, enter job name here
PATH: Full path name to output csv file directory
FNAME: Output CSV file name

CATEGORY can be delimted by a comma, semicolon or space.

The logic is quite fun, and is primarily based on the contents of the RT_LOGnnnn Universe file. The DS_JOBS file is parsed for all jobs that meet the parameter criteria, then for each job selected the RT_LOG and RT_STATUS files are interrogated for the relevant details, and an array of the details is built.

Jobs that are running are ignored. Jobs running over midnight or for several days are catered for, as are multiple instances of jobs.

The array is then squirted out, a job at a time, as a semicolon-delimited file.

laknar · Post by **laknar** » Thu Apr 26, 2007 12:49 pm

Can you give step by step code to store the log details into Excel file

Please provide me code.

In parallel jobs is preferrable.

Thanks & Regards,
laknar

ray.wurlod · Post by **ray.wurlod** » Thu Apr 26, 2007 4:56 pm

The jobs write to CSV files. You open these with Excel. Voila!

DSXchange

Can we export joblog to a file

Can we export joblog to a file

Re: Can we export joblog to a file