hello All,
is there any utility which can find the predecessor and successor of a job ???
find predessor and successor
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'
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'
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.