Hi
I'm working on getting a automated script to fetch the log details from the control-m repository, But i'm not very familiar with control-m repository,
Can you please provide a query/tables that gives me the jobs which ran today IN control M with below details of Job.
1.JOB_Name
2.JOB_START_DATE_TIME
3.JOB_END_DATE_TIME
4.JOB EXECUTED BY User ID
5.SERVER name IP Address of server where the job ran
6.JOB SESSION ID
7.JOB STATUS S --> Success, F --> Failure, U --> Unknown
8.JOB Error Message
9.JOB Error Code
10.JOB Error Type U-> User exception, S-> Server Failure
11.ALERT SEND FLAG P --> Action Pending, S --> Alert Send, N --> No action Reqd.
Thanks
Muthu
Status of jobs ran today.
- rahulsehgal
- Nouveau
- Posts: 148
- Joined: 19 Mar 2009 12:00
- Location: Delhi
- Contact:
Hi,
You can use Database Posters of Control-M different versions to fetch these information from Control-M database using your automated scripts, you can get information on the table repository using below link:-
http://www.scheduler-usage.com/modules. ... oad&cid=49
Regards,
Rahul Sehgal
You can use Database Posters of Control-M different versions to fetch these information from Control-M database using your automated scripts, you can get information on the table repository using below link:-
http://www.scheduler-usage.com/modules. ... oad&cid=49
Regards,
Rahul Sehgal