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.
How to get the orderno?
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.
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.
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.
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.
- parkerkevin73
- Nouveau
- Posts: 2
- Joined: 03 Mar 2011 12:00
How to get the orderno?
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
Re: How to get the orderno?
Use control-M Server utility ctmpsm -LISTALL
the first column of information is of orderid. you can further filter your jobs with grep.
the first column of information is of orderid. you can further filter your jobs with grep.
Re: How to get the orderno?
just login as control-m user on the control-m server and type p_36 <orderid>
Anirudh