utility to see the parameters of AJF

Tools and several solutions to manage Control-M products
Post Reply
User avatar
davidtuti
Nouveau
Nouveau
Posts: 73
Joined: 27 Dec 2006 12:00

utility to see the parameters of AJF

Post by davidtuti » 27 Aug 2009 3:53

Hi,

I would like to know if there is an utility to can see the parameter of jobs scheduled in AJF of for example, all memname that beginning by 'los*'.

That is possible?

Many thanks and sorry for my english!

User avatar
Walty
Nouveau
Nouveau
Posts: 473
Joined: 20 Jan 2006 12:00

Post by Walty » 27 Aug 2009 4:18

Hi,

suggestions:

- look the <ctmpsm> utility
ctmpsm -LISTALL MEMNAME | grep xxxx

- execute SQL query
select MEMNAME from CMR_AJF where MEMNAME like 'xxx%';
Best regards
Walty

User avatar
davidtuti
Nouveau
Nouveau
Posts: 73
Joined: 27 Dec 2006 12:00

Post by davidtuti » 27 Aug 2009 4:38

Walty wrote:Hi,

suggestions:

- look the <ctmpsm> utility
ctmpsm -LISTALL MEMNAME | grep xxxx

- execute SQL query
select MEMNAME from CMR_AJF where MEMNAME like 'xxx%';
Thanks!
But I would like to get the parameters of these memnames

User avatar
Walty
Nouveau
Nouveau
Posts: 473
Joined: 20 Jan 2006 12:00

Post by Walty » 27 Aug 2009 4:48

Hi,

Wich kind of 'parameters' do you search ?
Best regards
Walty

User avatar
davidtuti
Nouveau
Nouveau
Posts: 73
Joined: 27 Dec 2006 12:00

Post by davidtuti » 27 Aug 2009 5:38

Walty wrote:Hi,

Wich kind of 'parameters' do you search ?
Hi.
The name and the value of the tab set.

Thanks

User avatar
Walty
Nouveau
Nouveau
Posts: 473
Joined: 20 Jan 2006 12:00

Post by Walty » 28 Aug 2009 9:52

Hi,

I see only one SQL query for this.
If these are the definitions for AUTOEDIT variables used in your active jobs (AJF) try one query like this:

select distinct substr(a.SCHEDTAB,1,20) as "SchedTab",
substr(a.JOBNAME,1,20) as "Jobname",
substr(a.MEMNAME,1,20) as "Memname",
substr(b.VAREXPR,1,80) as "Autoedit PARM"
from CMR_AJF a, CMR_SETVAR b where a.ORDERNO = b.ORDERNO and MEMNAME like 'your_memname';
Best regards
Walty

Post Reply