try this :
ctmpsm -LISTALL | grep JOB | grep AAAAMMDD | grep -v Deleted | wc -l
grep JOB : is used in this filter to avoid GRP count (scheduling groups)
grep AAAAMMDD : is used to only show ODAT jobs
grep -v Deleted : is used to avoid deleted jobs from active jobs
wc -l : is used (aix command) to count lines (in this case jobs).
note: If you have recoursive jobs or cyclic jobs, you can't count how many jobs you will run. I have a Excel page with my inventory and calculate ciclyc jobs and recoursive jobs (jobs not created in desktop, jobs created using ctmcreate commando when i need).
Report of jobs running on day
Hi,
you can use the <ctmlog> utility
ctmlog listmsg <msgid> <From Date> <From Time> <To Date> <To Time> <output> <reportWith>
where msgid=5133 for Job ENDED OK
where msgid=5134 for Job ENDED NOTOK
Example for KO jobs
ctmlog listmsg 5134 20090527 0000 20090527 2359 /tmp/jobs-ko.log 132
When you have the flat file you can execute what you want.
You can construct daily audit with other msgid like:
msgid=5401 for job HELD
msgid=5402 for job FREED
msgid=5403 for job DELETED
msgid=5404 for job RERUN
msgid=5405 for job CONFIRMED
msgid=5408 for job UNDELETED
msgid=5409 for job KILLED
msgid=......
you can use the <ctmlog> utility
ctmlog listmsg <msgid> <From Date> <From Time> <To Date> <To Time> <output> <reportWith>
where msgid=5133 for Job ENDED OK
where msgid=5134 for Job ENDED NOTOK
Example for KO jobs
ctmlog listmsg 5134 20090527 0000 20090527 2359 /tmp/jobs-ko.log 132
When you have the flat file you can execute what you want.
You can construct daily audit with other msgid like:
msgid=5401 for job HELD
msgid=5402 for job FREED
msgid=5403 for job DELETED
msgid=5404 for job RERUN
msgid=5405 for job CONFIRMED
msgid=5408 for job UNDELETED
msgid=5409 for job KILLED
msgid=......
Best regards
Walty
Walty
can i have the above mentioned command for windows server
we are in windows environment and i want to know all the jobs that ran on particular node(server) on a particular date .....
KINDLY HELP IT IS URGENT
KINDLY HELP IT IS URGENT
use the ctmlog commands as shown above and combine withe the windows equivalent of grep (which, I think, is FINDSTR).
For example, if I wanted to search on yesterday and see any time the node had gone unavailable -
ctmlog LISTMSG 5222 090610 0400 090610 2000 |findstr /i /r "problem_node_here"
(with your agent inside the quotes)
However it might be better just to look for the agent name in general -
ctmlog LIST 090610 0400 090610 2000 |findstr /i /r "problem_node_here"
We don't Windows for the Control-M Server, so I cannot test the above.
For example, if I wanted to search on yesterday and see any time the node had gone unavailable -
ctmlog LISTMSG 5222 090610 0400 090610 2000 |findstr /i /r "problem_node_here"
(with your agent inside the quotes)
However it might be better just to look for the agent name in general -
ctmlog LIST 090610 0400 090610 2000 |findstr /i /r "problem_node_here"
We don't Windows for the Control-M Server, so I cannot test the above.
Hi,
i suggest to schedule a daily job to archive the Controlm log.
ctmlog <Action> <From date> <From Time> <To Date> <To Time> [<Output> [<Report Width>] ]
Example:
ctmlog list 090616 0000 090617 0000 <your_yymmdd.log> 132
After it's easy to find some informations in the file.
If you have implemented the <ctmjsa> utility try the <ctmruninf> utility
You find statistics data from each successful job execution.
CTMRUNINF usage:
ctmruninf -list <fromtime> <untiltime> [<filter...>] [-total]
ctmruninf -delete <fromtime> <untiltime>
ctmruninf -purge
fromtime, untiltime : YYYYMMDDHHMMSS
filters : -JOBNAME <jobname>
-MEMNAME <memname>
-MEMLIB <memlib>
-NODEID <nodeid>
-ORDERID <orderid>
The <filter..> parameter is optional.
-total : Prints number of records, total CPU & ELAPSED times
NOTE: only first 10 characters of JOBNAME field are displayed.
ctmruninf -list YYYMMDDHHMMSS YYYMMDDHHMMSS -NODEID <nodeid>
ctmruninf -list "*" -JOBNAME <jobname>
ctmruninf -list "*" -NODEID <nodeid>
i suggest to schedule a daily job to archive the Controlm log.
ctmlog <Action> <From date> <From Time> <To Date> <To Time> [<Output> [<Report Width>] ]
Example:
ctmlog list 090616 0000 090617 0000 <your_yymmdd.log> 132
After it's easy to find some informations in the file.
If you have implemented the <ctmjsa> utility try the <ctmruninf> utility
You find statistics data from each successful job execution.
CTMRUNINF usage:
ctmruninf -list <fromtime> <untiltime> [<filter...>] [-total]
ctmruninf -delete <fromtime> <untiltime>
ctmruninf -purge
fromtime, untiltime : YYYYMMDDHHMMSS
filters : -JOBNAME <jobname>
-MEMNAME <memname>
-MEMLIB <memlib>
-NODEID <nodeid>
-ORDERID <orderid>
The <filter..> parameter is optional.
-total : Prints number of records, total CPU & ELAPSED times
NOTE: only first 10 characters of JOBNAME field are displayed.
ctmruninf -list YYYMMDDHHMMSS YYYMMDDHHMMSS -NODEID <nodeid>
ctmruninf -list "*" -JOBNAME <jobname>
ctmruninf -list "*" -NODEID <nodeid>
Best regards
Walty
Walty