How to find an ORDERID using a scheduled job?

[bsglover]

Hi guys,
i need to put a job in hold state just after another execution finish KO, i did get the right command:

"ctmpsm -UPDATEAJF (ORDER-ID) HOLD"

I dont know how to get, in automatic, the order_id of the job i need to hold.

My idea is create a script which can be launched after the other execution finish KO. The KO job has a monthly schedule and the one i have to hold has a daily execution (the last one of a whole flow).

System info:
Win server 2003 sp3
Control-m 6.4

Thanks in advance for the advices.

[nicolas_mulot]

Bsglover,

The orderid of the target job is accessible from the CMR_AJF table. The value returned is numeric, instead of alphanumeric. For example, if your target job has an orderid of abc, the returned value will be 13368.

The ctmpsm utility accepts decimal orderids: in that case, the value should be prefixed with an asterisk and enclosed in doublequotes, as shown below:

ctmpsm –updateajf “*13368” hold

You have to strictly identify your target (daily) job using as many SQL selection criteria as required such as the jobname, the application, the odate etc…

Running an sql sequence such as:

select ‘ctmpsm –updateajf “*’
+ ltrim(str(ORDERNO)
+ ‘” hold’
where APPLIC = (your application)
and ODATE = (YYYYMMDD)
and JOBNAME = (your daily jobname)
.. will give you directly the required command.

If you are using MS/SQL I could forward you a kind of sample which works

Cheers
Nicolas Mulot

[bsglover]

Thanks for the answer, i will try asap.