looking for a script that list MVS job

[arno76]

Hello,

i d like to know if it s possible to send a script to controlm like

select a.APPLIC,";",a.APPLGROUP,";",a.JOBNAME,";",a.MEMNAME,";",b.STARTRUN,";",b.ENDRUN,";",b.ELAPTIME,";",b.OSCOMPSTAT,";",b.NODEID
from CMR_AJF a,CMR_RUNINF b
where a.ORDERNO=b.ORDERNO
and
a.STATUS="N"
ORDER BY APPLIC

but for MVS.I know there are some utilities for MVS but i d like to use ORACLE SQL.

Thanks

[mauriziog]

If you have the EM server connected to the MVS server, and you see from EM the MVS jobs you have also the AJF of MVS server table on the open DB. So you can run the query you want.

[ranger67]

It is not possible to do that as there is no database on the MVS environment. However, you can query CTM/EM for most of this information for the MVS environment. Based on your query below, the only item you would be missing is compstat. You could get status and state which can tell you if it has run and has it run to good completion. The only other thing to remember is that you'll need to query dynamic tables which are created daily at newday. These are easy to get by doing something like this:

select MAX(name) from sysobjects where name like "A%DC%JOB"

you would replace DC with the datacenter specifier from when you defined the datacenters to EM.

Hope this helps.

[arno76]

thanks for answers, but have you got exemple of script to run?
must i run this on EM? if yes by which command?
have you got a list of the Dynamic Table?

thanks in advance

[mauriziog]

If you have almost two ctm/server:
ctmopen + ctmmvs and one EM that have two gateway, one on MVS and one on ctmopen; you have a table in the EM/DB that has a name like this:
A080923MVS_AJOB
is the AJF table for MVS jobs for today where "080923" is YYMMDD date format for today.

So you can for example do this query:

$query="SELECT JOB_NAME, GROUP_NAME, ORDER_ID, APPLICATION, NEXT_TIME, STATUS, STATE FROM A080923MVS_AJOB WHERE (GROUP_NAME = 'GroupName')";

or other as you like.

[Walty]

In addition of 'mauriziog' post if you run this command:

<select ACTIVE_NET_NAME from COMM>

You find out the 'Active Net Name' named <TableCode> for each datacenter.

Please note:
- That it's necessary to prefix the <TableCode> results with "A"
- The name of 'Active Net Name' change every time when one <download> action is occured (Control-M/MVS or Control-M/Server to Control-M/EM)

Regards
Walty

[arno76]

thank you very nuch, thats work fine ...
just a little one
how can i put the result of the query SELECT JOB_NAME, GROUP_NAME, ORDER_ID, APPLICATION, NEXT_TIME, STATUS, STATE FROM A080924003_AJOB; into a file?

thanks

[Walty]

Example:

SQL -s << EOF >> your file
SELECT JOB_NAME, GROUP_NAME, ORDER_ID, APPLICATION, NEXT_TIME, STATUS, STATE FROM A080924003_AJOB;
EOF