Clear Job Log from DSAdministrator

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Clear Job Log from DSAdministrator

Post by cherry »

Hi All,

Is there any way to clear the job log for a particular job from Administrator Command prompt.

Thanks in Advance..,

Regards
Cherry
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

CLEAR.FILE RT_LOGnnn where 'nnn' is the internal job number of the job in question. You'll then need to re-establish your auto-purge settings as they will be gone as well.
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

OK... that answer assumes they are still being stored in the "Universe" repository, which may or may not be the case depending on your exact 8.x version and certain settings.
-craig

"You can never have too many knives" -- Logan Nine Fingers
SBSA_DW
Premium Member
Premium Member
Posts: 6
Joined: Thu Jul 24, 2008 1:53 am

Clear job log from DSAdministrator

Post by SBSA_DW »

chulett wrote:CLEAR.FILE RT_LOGnnn where 'nnn' is the internal job number of the job in question. You'll then need to re-establish your auto-purge settings as they will be gone as well. ...
I guess the issue at hand is how do you get internal number (nnn) for the job in administrator so you can clear the log using the command CLEAR.FILE RT_LOGnnn ; in cases where you do not know the internal number. In Windows os

Regards
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It's been discussed and posted here many times. Once more, for the record:

Code: Select all

SELECT JOBNO FROM DS_JOBS WHERE NAME = 'YourJobName';
-craig

"You can never have too many knives" -- Logan Nine Fingers
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Post by cherry »

Heelo everyone,

Thanks for the quick response. That was really a very useful information for me. I got my problem solved by your responses.

Thanks for evryone..

Regards
Cherry
Post Reply