Delete Log

[shrey3a]

Hi,

We have numerous prod jobs which makes the log full.

We have a scenario where we want to know which job has created the particular log.

Is there is any routine/ utility which can give the tell which log file is been created by which job.

Thanks in advance.....
Regards

[kcbland]

Search the forum, there's a method recently discussed to select from the DS_JOBS hash file to get a job's internal storage number. That number is used in the naming convention for the supporting hash files of a job design (RT_LOGnnnn being the one in which you're interested).

[vcannadevula]

Hi,

We have numerous prod jobs which makes the log full.

We have a scenario where we want to know which job has created the particular log.

Is there is any routine/ utility which can give the tell which log file is been created by which job.

Thanks in advance.....
Regards

Easiest way is to go to the ADministrator and select the Command and run the following SQL

select * from DS_JOBS where NAME = 'jobname'

this will give you the RT_LOGNN number for the job.

do the select * from RT_LOGNN to see the logs.

[ray.wurlod]

Hi,

We have numerous prod jobs which makes the log full.

We have a scenario where we want to know which job has created the particular log.

Is there is any routine/ utility which can give the tell which log file is been created by which job.

Thanks in advance.....
Regards

The Director client does this. Select the job in question, switch to Log view, and you're inspecting the correct log. Yay!