How can I view job logs for previous days under version 6.1?

vicpylon · Post by **vicpylon** » 15 Oct 2007 6:05

When I right-click on a job and choose "log." I can see the specific events for that job. My question is, since 6.1 does not have an archive view point function, where does the system store this information? Is it on the server or on the job node somewhere?

Thank you,

Vic

vicpylon · Post by **vicpylon** » 15 Oct 2007 7:32

The log information that you see when you click on the job in the EM and choose "log" is actually held in the CONTROL-M/Server database in the CMR_IOALOG table.

philmalmaison · Post by **philmalmaison** » 16 Oct 2007 9:57

you can choose in controlm server parameter how many days log you want to keep
regards
philmalmaison

philmalmaison · Post by **philmalmaison** » 16 Oct 2007 4:18

archive your controlm log by using ctmlog list <from> <from> <to> <to> > yourfile

ex: i archive the controlm log on a daily basis.

ctmlog list %%$PREVDATE 1000 %%$ODATE 1000 > myfile.`date`

so i can retrieve everythink making some grep ...

i keep 30 days

arno76 · Post by **arno76** » 11 Sep 2008 2:45

philmalmaison wrote:archive your controlm log by using ctmlog list <from> <from> <to> <to> > yourfile

ex: i archive the controlm log on a daily basis.

ctmlog list %%$PREVDATE 1000 %%$ODATE 1000 > myfile.`date`

so i can retrieve everythink making some grep ...

i keep 30 days

hello,

is %%$PREVDATE created by another job? or is it a ctrlm variable, like autoedit?

thanks

hipikll · Post by **hipikll** » 11 Sep 2008 3:46

%%PREVDATE is standard variable - means - date of the previous production day (if i remember)

arno76 · Post by **arno76** » 15 Sep 2008 12:25

hipikll wrote:%%PREVDATE is standard variable - means - date of the previous production day (if i remember)

Hello,

I've try but Prevdate is not standard variable i think ..
can you help me on how to define it?

thanks

mauriziog · Post by **mauriziog** » 16 Sep 2008 2:15

but Prevdate is not standard variable i think

From documentation of system variables:

%%$PREV yyyymmdd Previous scheduling date for the job (4-digit
year).

I create a log each day after ND and I save it with Time Stamp I keep them for 1 year in compressed archive (zip).
In my case the archived view point respond very well for what is run 7-10 days before. But if the question is about a run one or two month ago ?
In this manner I have always the execution log.

How can I view job logs for previous days under version 6.1?

How can I view job logs for previous days under version 6.1?

Found the answer to my own question