CODEWITHSUNDEEP
jobscontrol-m
user1474157
user1474157

Reputation: 1583

How to check which jobs use a particular IN condition in Control-M

I am using Control M Enterprise manager to track jobs. I have a job with OUT-condition as 'X_OK'. i am not sure if/where a job is using this as IN-condition. Is there any way i can search for jobs which have this particular condition as IN-condition. Thanks.

Upvotes: 0

Views: 7597

Answers (4)

Dan
Dan

Reputation: 41

  • Download the physical data model of your version of Control-M: ftp://ftp.bmc.com/pub/control-m/opensystem/DB_Schemas/
  • Connect to your Control-M database
  • To search input conditions look in the tables def_job and def_lnki_p
  • To search output conditions look in the tables def_job and def_lnko_p

Example: 

-- Display all job names that use the IN condition "aaabbbccc"
SELECT 
  job_name
FROM 
  emuser.def_lnki_p, 
  emuser.def_job 
WHERE 
  def_lnki_p.table_id = def_job.table_id AND
  def_lnki_p.job_id = def_job.job_id AND
  def_lnki_p.version_serial = def_job.version_serial AND
  LOWER(def_lnki_p.condition) LIKE '%aaabbbccc%';

Upvotes: 1

Raja
Raja

Reputation: 26

Use Neighborhood option . It will give u list of Successor and predecessor jobs

Upvotes: -1

user1474157
user1474157

Reputation: 1583

In the latest Control M workload automation there is an option for searching for jobs having particular IN or OUT condition. Just type the condition and search.

Upvotes: 1

Justin
Justin

Reputation: 102

All the jobs that are set up in Control M will show the arrows that are connected to each other. So, If X is connected to different jobs, then that will be shown through the out going arrows from X. Also, if you are finding it difficult to find out this way, do the followign on job X, and you can find out jobs that use the X's OUT condition as their IN condition - Right Click (on Job X) -> Branch Menu -> Successor -> (The jobs displayed here use the X's OUT-condition as their IN-condition)

Upvotes: -1

Related Questions