Unix command for clearing datastage job logs.

[jpradeep.net]

I built a script which ckecks the status for all datastage jobs in a project and clears the log if the status of the job is successful. I used the "CLEAR.FILE RT_LOG" $project_name $job_name which is throwing an error as "Unable to clear file RT_LOG." I heard that CLEAR.FILE command resets the auto purge properties for the job which we want to clear the log.Can anyone help me by providing the command for clearing the job log with out resetting the auto purge properties?

[chulett]

You are missing the job number from the clear command. Each job has a unique number assigned to it that all of the internal structures are tagged with:

CLEAR.FILE RT_LOG1234

You can get the number by querying DS_JOBS:

Code: Select all

SELECT JOBNO FROM DS_JOBS WHERE NAME = 'YourJobName';

I'm not aware of any command to purge logs without losing the auto-purge values.

[qt_ky]

I still use this command to get the job ID:

Code: Select all

LIST DS_JOBS WITH @ID=job_name

[chulett]

Or that.

[qt_ky]

It's less to type.

And a word of caution: Don't run DELETE.FILE accidentally or you will have damage to repair.

[pandeesh]

Thanks Eric.
going forward i will use this:

Code: Select all

LIST DS_JOBS WITH @ID=job_name