It is currently 21 Jul 2017 12:29


Post new topic  Reply to topic  [ 5 posts ] 
Author Message
PostPosted: 11 Apr 2014 9:00 
Offline
Nouveau
Nouveau
User avatar

Joined: 21 Sep 2013 8:00
Posts: 48
hello All,

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

_________________
Anirudh


Top
   
 Post subject:
PostPosted: 11 Apr 2014 11:11 
Offline
Nouveau
Nouveau
User avatar

Joined: 14 Jan 2010 9:00
Posts: 58
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'


Top
   
 Post subject:
PostPosted: 14 Apr 2014 6: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.


Top
   
 Post subject:
PostPosted: 15 Apr 2014 4:24 
Offline
Nouveau
Nouveau
User avatar

Joined: 21 Sep 2013 8:00
Posts: 48
When i run the belo query it shows no table exist....

_________________
Anirudh


Top
   
 Post subject:
PostPosted: 19 Apr 2014 5:59 
Offline
Nouveau
Nouveau
User avatar

Joined: 14 Jan 2010 9:00
Posts: 58
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


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 5 posts ] 

All times are UTC+10:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved