find predessor and successor

Tools and several solutions to manage Control-M products
Post Reply
User avatar
anirudhrh
Nouveau
Nouveau
Posts: 48
Joined: 21 Sep 2013 12:00

find predessor and successor

Post by anirudhrh » 11 Apr 2014 1:00

hello All,

is there any utility which can find the predecessor and successor of a job ???
Anirudh

User avatar
jstarkw
Nouveau
Nouveau
Posts: 58
Joined: 14 Jan 2010 12:00

Post by jstarkw » 11 Apr 2014 3:11

Hi,

I wrote a mssql query that can find this info. You may need to modify if your database is Oracle or Postgres. Also written for controlm v6.4 database.

Get jobname, in/outconditions, and cmd line.

SELECT a.CONDITION AS "In Condition",c.GROUP_NAME AS "Group Name",c.JOB_NAME AS "Job name",
b.CONDITION AS "Out Condition", c.CMD_LINE AS "Command Line"
FROM ((DEF_VER_JOB c
LEFT JOIN DEF_VER_LNKI_P a
ON
c.TABLE_ID = a.TABLE_ID and c.JOB_ID = a.JOB_ID and c.VERSION_SERIAL = a.VERSION_SERIAL)
LEFT JOIN DEF_VER_LNKO_P b
ON
c.TABLE_ID = b.TABLE_ID and c.JOB_ID = b.JOB_ID and c.VERSION_SERIAL = b.VERSION_SERIAL)
WHERE
c.APPLICATION='application name' and
c.GROUP_NAME='group name' and
c.GROUP_NAME!=c.JOB_NAME and
c.IS_CURRENT_VERSION='Y'

bbbggg456

Post by bbbggg456 » 14 Apr 2014 10:53

Football is a wonderful sport. fifa coins cheap Here is the sport enjoyed and entertained by every day nation present in this world of ours. Starting at an early age of 6 at the oldest worker living back to planet likes to watch nfl matches. But their interest height vary with individuals. Some eats it fairly and aspires to become a professional. Some takes it as hobby just for maintaining health. Some just loves to watch their favorite sides under action while other people loves to play virtual tennis games games. buy cheap fifa 14 ultimate team coins There are some who aspires to achieve involved at the back ground of all sport. This involves managing edge, becoming coaches and physios, reporter or at least administrator edge of the treatment of the aspects etc.

User avatar
anirudhrh
Nouveau
Nouveau
Posts: 48
Joined: 21 Sep 2013 12:00

Post by anirudhrh » 14 Apr 2014 8:24

When i run the belo query it shows no table exist....
Anirudh

User avatar
jstarkw
Nouveau
Nouveau
Posts: 58
Joined: 14 Jan 2010 12:00

Post by jstarkw » 18 Apr 2014 9:59

Hi,

Did you replace 'application name' and 'group name' with:

c.APPLICATION='application name' and
c.GROUP_NAME='group name' and

With your actual application and group name you are using?

IE c.APPLICATION='Batch_run1' and
c.GROUP_NAME='D_run1

Post Reply