I am some problem about purge job log in Datastage Server.
I need to purge job log via command not in Director!
Do anyone know how to use command (not in Administrator or uv) to purge all log in a job ?
Best Regards!
HOW to Delete Job Log via Command?
Moderators: chulett, rschirm, roy
Welcome to DSXChange.
There is no built-in command with which you can delete a specific job's log file contents. It is possible to write some some in BASIC to do this and I think that parts have been posted here before.
It is best to stick with the standard purge mechanism, i.e. purging a job's log automatically after n-days or n-executions.
There is no built-in command with which you can delete a specific job's log file contents. It is possible to write some some in BASIC to do this and I think that parts have been posted here before.
It is best to stick with the standard purge mechanism, i.e. purging a job's log automatically after n-days or n-executions.
</a>
Re: HOW to Delete Job Log via Command?
Welcome Aboard,tjhaosse wrote:I need to purge job log via command not in Director!
Care to elaborate on that?
If you do a command line purge it will remove the default purge settings. And if you forget to run the command again, your log file will grow without any check. Hence ArndW's suggestion of setting with Director's auto purge settings.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
The posts Arnd talks about have \\PURGE.SETTING in them. Do a search. You can do a SQL DELETE to delete the rows without removing your purge settings. It is possible. Maybe not recommended. Ken Bland has a job or routine on his web site to set all the purge settings for every job. Look for that routine. Maybe a combination of his code and something else will get you what you really want.
Mamu Kim