Know the Successors

[meon344]

Guys,

I've a request to look for successors for an existing job. The job with Maybe conditions has different successors on different days. So, we cannot find through the net option used in AJF . Any suggestions would be appreciable

[GNappo]

Hi meon344,

you can user the Neighborhood utility by clicking with dx of mouse on interested job.

This utility can be user in Control-M EM and in Control-M Desktop. You can also save a report with result of your request

Best Regards

Giuseppe Nappo

[icemanCTM]

father jobs (recursive):

SelectQuery = e.sched_table , c.job_name as , c.group_name, c.APPLICATION

FromQuery= def_job c, def_lnko_p d,def_tables e

$WhereQuery = d.condition in (select b.condition from def_job a,def_lnki_p b where a.job_name='MyJob' and a.APPLICATION='MyAplicacion' and a.group_name='MyGrupo' and a.table_id=b.table_id and a.job_id=b.job_id) and d.table_id=c.table_id and d.job_id=c.job_id and c.table_id=e.table_id

[icemanCTM]

father jobs (recursive):

SelectQuery = e.sched_table , c.job_name as , c.group_name, c.APPLICATION

FromQuery= def_job c, def_lnko_p d,def_tables e

$WhereQuery = d.condition in (select b.condition from def_job a,def_lnki_p b where a.job_name='MyJob' and a.APPLICATION='MyAplicacion' and a.group_name='MyGrupo' and a.table_id=b.table_id and a.job_id=b.job_id) and d.table_id=c.table_id and d.job_id=c.job_id and c.table_id=e.table_id