Page 1 of 1

Clear Job Log from DSAdministrator

Posted: Wed Aug 05, 2009 5:58 am
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

Posted: Wed Aug 05, 2009 6:03 am
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.

Posted: Wed Aug 05, 2009 6:04 am
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.

Clear job log from DSAdministrator

Posted: Wed Aug 05, 2009 6:55 am
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

Posted: Wed Aug 05, 2009 7:59 am
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';

Posted: Wed Aug 05, 2009 8:08 am
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