Predecessors and Sucessors

Some examples running with Control-M and Control-EM database.
Post Reply
elopresti

Predecessors and Sucessors

Post by elopresti » 12 Dec 2006 9:46

Hi!
Can you give me some information or a query to obtain the same result as the options "Predecessors" and "Sucessors" available from the context menu of a Job?
I need this info from the job definitions, not from the active job file.

Regards,
EDL

User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Post by fyot » 12 Dec 2006 9:57

Hi,

What do you mean exactly.
Do you want only to know how to obtain from an SQL command condition IN and OUT from a Job definition ?

elopresti

Predecessors and Sucessors

Post by elopresti » 19 Dec 2006 4:51

In CTM Desktop o CTM EM, when I right-click on a job, the options "Branch Menu/Predecessors" and "Branch Menu/Sucessors" show exactly what I need.
The "Neighborhood" Reports show similar information (predecessors and dependants), but not the same...
I know it has to do whith IN/OUT conditions, but only those that "link" jobs.
I need a query with the same result.

Thanks in advance,
Eduardo

Epping

Post by Epping » 30 Apr 2007 3:27

don't know if this helps.. where xxxxxxx = condition name. This checks in/out conditions and tells you the job name, table name



select distinct c.Data_Center, c.sched_table, a.Job_Name, a.Days_Cal, a.W_day_str , d.condition outcondition, d.odate, d.sign, e.condition incondition, e.odate, e.and_or
from emadmin.def_job a, emadmin.def_tables c , emadmin.def_lnko_p d, emadmin.def_lnki_p e
where a.Table_id=c.Table_id
and (d.condition = ('xxxxxxxxxxxx') or e.condition = ('xxxxxxxxxxxxxxxxxxx'))
and (a.Table_id=d.Table_id and a.Job_id = d.Job_id)
and (a.Table_id=e.Table_id and a.Job_id = e.Job_id)
order by 1,2,3,4

Post Reply