It is currently 20 Aug 2018 4:36


Post new topic  Reply to topic  [ 9 posts ] 
Author Message
 Post subject: How to get the orderno?
PostPosted: 15 Jan 2008 11:42 
Hello,

I want to get some information from the server database for a specific job. I am able to run a program after a job is submitted and before it is executed. Because of that I think it could be a good idea to get the orderno of the current job from the server database (maybe cmr_ajf table or with a command) and with this orderno build a query, but I don´t know how to do that.

Is possible to get which is the orderno for the current job? or Is there another
way (maybe better) to know which one is the current job and to get all the information you need about it?

Thanks in advance.


Top
   
 Post subject:
PostPosted: 15 Jan 2008 4:14 
http://www.scheduler-usage.com/modules. ... opic&t=401

maybe this can help you


Top
   
 Post subject:
PostPosted: 16 Jan 2008 10:51 
Thanks hipikll,

the link is useful, but I have the problem that I don´t have a GUI, the only information I can manage is the server database, so I have to find the information about the orderno (or jobno) on it (running a sql query or a Control-M command/utility on my program), so that is what I am looking for, a sql query or a command / utility that could help me.

Thanks.


Top
   
 Post subject:
PostPosted: 16 Jan 2008 2:33 
hm, so when the job A is ordered, you have no information about it - for example from EM GUI or from ctmorder command?
So you know only the job name and nothing more?
I have the DB structure for CM, but I never used direct sql queries.

How about using ctmlog listjobname <job_name> ... (see manual).
From this command you can obtain the orderid and then transfer it to orderno of specified job.


Top
   
 Post subject:
PostPosted: 23 Apr 2008 4:13 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 807
Location: Varese - Italy
The orderid of a job?
Use the variables: %%ORDERID is the order id of the current job.
So if for example you have 2 jobs: JOB1 and JOB2 and in the JOB2 you want the orderid of the JOB1 do this:

- In JOB1 var panel:
\%%JOBORDER=%%ORDERID

- In JOB2 use this variable:
echo %%JOBORDER for example.


Top
   
 Post subject: How to get the orderno?
PostPosted: 05 Mar 2011 8:09 
Offline
Nouveau
Nouveau
User avatar

Joined: 03 Mar 2011 12:00
Posts: 2
You can get the database for the server database for a specific jobs and the run the program and submitted before the execution it helps the orderno to server database You can take the order no to built a query.

_________________
SEO


Top
   
 Post subject:
PostPosted: 26 Feb 2014 9:04 
Offline
Nouveau
Nouveau
User avatar

Joined: 21 Sep 2013 12:00
Posts: 48
p_36 <orderid>

_________________
Anirudh


Top
   
PostPosted: 27 Feb 2014 7:05 
Offline
Nouveau
Nouveau
User avatar

Joined: 18 Jan 2014 12:00
Posts: 27
Use control-M Server utility ctmpsm -LISTALL
the first column of information is of orderid. you can further filter your jobs with grep.


Top
   
PostPosted: 11 Jun 2015 6:22 
Offline
Nouveau
Nouveau
User avatar

Joined: 21 Sep 2013 12:00
Posts: 48
just login as control-m user on the control-m server and type p_36 <orderid>

_________________
Anirudh


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

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 2 guests


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