query to find failed jobs in active network ?

Some examples running with Control-M and Control-EM database.
Post Reply
User avatar
anirudhrh
Nouveau
Nouveau
Posts: 48
Joined: 21 Sep 2013 12:00

query to find failed jobs in active network ?

Post by anirudhrh » 21 Feb 2014 5:21

query to find failed jobs in active network ?
Anirudh

User avatar
sunuriyal
Nouveau
Nouveau
Posts: 27
Joined: 18 Jan 2014 12:00

Re: query to find failed jobs in active network ?

Post by sunuriyal » 21 Feb 2014 5:50

you can do it by ctmpsm utility. Please let me know if you need more info.

User avatar
anirudhrh
Nouveau
Nouveau
Posts: 48
Joined: 21 Sep 2013 12:00

Post by anirudhrh » 22 Feb 2014 6:53

yes i want jobs which are of particular names somthing like %abc% and also for the present odate....
Anirudh

User avatar
sunuriyal
Nouveau
Nouveau
Posts: 27
Joined: 18 Jan 2014 12:00

Post by sunuriyal » 24 Feb 2014 5:06

you can use-

ctmpsm -LISTALL |grep "NOTOK" |grep "JobName"

This will output you with current ODAT as you want.
Hope this helps ..

User avatar
anirudhrh
Nouveau
Nouveau
Posts: 48
Joined: 21 Sep 2013 12:00

Post by anirudhrh » 24 Feb 2014 5:13

one more help ... what if i want the sysouts of the faileds jobs in email ...
Anirudh

User avatar
sunuriyal
Nouveau
Nouveau
Posts: 27
Joined: 18 Jan 2014 12:00

Post by sunuriyal » 25 Feb 2014 7:08

you can do this by step tab of Jobs-

On - NOTOK
Do - sysout handling ..

User avatar
anirudhrh
Nouveau
Nouveau
Posts: 48
Joined: 21 Sep 2013 12:00

Post by anirudhrh » 25 Feb 2014 8:28

HOW ABOUT if i need jobs of specific odate?
Anirudh

User avatar
sunuriyal
Nouveau
Nouveau
Posts: 27
Joined: 18 Jan 2014 12:00

Post by sunuriyal » 27 Feb 2014 7:09

Store an ouput of above commands I told in a file i.e JobsNotOk.
then

cat JobsNotOk |grep "mention odat you want"

this will output only the jobs with that specific odat you mention above.

Post Reply