Scheduler Usage

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

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