where are the log files for DS

[hiltsmi]

I know how to use Director to view job logs. I would like to view/use the job logs outside of the director.

Where does DS store job logs? Are they in a text file that can be edited?

[djm]

Try this thread: viewtopic.php?t=95633.

David

[chulett]

Where does DS store job logs? Are they in a text file that can be edited?

David seems to have thrown you straight into the Advanced Placement class when it doesn't even seem like you've taken the 101 version yet.

In addition to all that, the simple answer is 'no' - they are not text files. You'll soon find that the vast majority of information stored in the repository is stored in hashed files just like you would use in a job, and the logs are no exception. Each job is assigned a number when it is created and a series of hashed files are created to hold its design, object code, logs, etc. Have a peek inside one of your Project directories and you'll see.

[djm]

But Craig, my reply was (like my forum moniker) short and to the point

[ray.wurlod]

<musing>
I note that we have a poster called ak77. I wondered if there's an ak47.
</musing>

[ArndW]

The newer model is the ak74. Played with one of those, the ak47 is better.

[chulett]

But Craig, my reply was (like my forum moniker) short and to the point

Yes, that it was. :D

Not sure what Ray and Arnd are prattling on about, however...

[ray.wurlod]

Does the word "Kalashnikov" rattle any eardrums?

I fear we're drifting off topic again.

[chulett]

Oh, perfectly well aware of what a Kalashnikov AK47 is - just wasn't quite sure of the relevance to the topic being discussed.

And as we drift ever further from the dock... I guess the connection was short usernames. Not nice to poke fun at 'short' people. And you know Arnd has a soft spot for automatic weapons.

[kduke]

You guys are on another wave length.

[htrisakti3]

hi KDuke,
I downloaded etlstat & imported into DS but now I cannot delete them.. ?

This solution does not work for me, because we have very limited access to DB, therefore I'm still searching for solutions based on hash or files only (anything that's only limited to ds, w/o touching DB)'

Thanks - HT

[kcbland]

Use the dsjob API to dump log summaries. If you want full log dumps, youre going to have to write something using intenal knowledge of the job repository. The APIs are not complete enough to give you full dumps of the job log.

The simplest thing to do is cross-reference the job name to the job number out of DS_JOBS. Then, dump out the hash file RT_LOGnnn where nnn is the job number. You'll have to learn DS BASIC and figure out how to sort and normalize the data.

One thing to consider is writing a DS job to point at the RT_LOGnnn file using the hash file stage and stream the output to a sequential file. The hash file will have to be a job parameter that can change from one run to another. That will allow you to more easily parse that log file. At least poke around and see what you can come up with.

[kduke]

hi KDuke,
I downloaded etlstat & imported into DS but now I cannot delete them.. ?

This solution does not work for me, because we have very limited access to DB, therefore I'm still searching for solutions based on hash or files only (anything that's only limited to ds, w/o touching DB)'

Thanks - HT

You can run this against hash files. You can change all the stage types to hash files in job DSJobReportDb. Also why can't you delete these jobs? When you use hash files the DSN is localuv. Leave the user and password blank for localuv. The job GenHtmlJobLog uses SQL to extract the log. This could easily be changed into a UV stage and extract the RT_LOGnnn file directly. You would need to change the nnn into a job parameter like RT_LOG#JobNo#. Anyway here are the SQL statements from the job above.

Code: Select all

      SqlStmt = ''
      SqlStmt< 1> = 'select'
      SqlStmt< 2> = '   TIMESTAMP,'
      SqlStmt< 3> = '   SEVERITY,'
      SqlStmt< 4> = '   FULL.TEXT'
      SqlStmt< 5> = 'from'
      SqlStmt< 6> = '   RT_LOG':JobNo
      SqlStmt< 7> = 'where'
      SqlStmt< 8> = '   EVAL "@ID" NOT LIKE ':"'//%'"