Status of jobs ran today.

Several scripts
Post Reply
somasunm

Status of jobs ran today.

Post by somasunm » 20 Jan 2010 12:30

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

User avatar
rahulsehgal
Nouveau
Nouveau
Posts: 148
Joined: 19 Mar 2009 12:00
Location: Delhi
Contact:

Post by rahulsehgal » 20 Jan 2010 12:55

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

Post Reply