Mass Update for Auto Edit Variable
- rahulsehgal
- Nouveau
- Posts: 148
- Joined: 19 Mar 2009 12:00
- Location: Delhi
- Contact:
Mass Update for Auto Edit Variable
Hi,
I have around 500 jobs for which I have to update Auto Edit Variable.
Do we have any mass update feature for Auto edit variables in Control-M/EM Desktop?
Regards,
Rahul Sehgal
I have around 500 jobs for which I have to update Auto Edit Variable.
Do we have any mass update feature for Auto edit variables in Control-M/EM Desktop?
Regards,
Rahul Sehgal
Hi,
In v6.3 the Mass Update feature is not possible for SET VAR values of Job Definitions.
Suggestion is to use <exportdeftable> or <exportdefjob>
This utilities first export the data from CONTROL-M/Enterprise Manager database to a flat file (xml format)
Then make the required changes from outside of CONTROL-Min in the flat file (by owner script or using text editor like UltraEdit)
The next step is to import the flat file back into the CONTROL-M/Enterprise Manager database using the <deftable> or <defjob> utility.
More information on these utilities is available in the CONTROL-M/EM Utility Guide.
Or use the <ctmexdef> utility
The ctmexdef utility exports job processing definitions from the CONTROL-M/Server database to a flat (ASCII) file.
Then make the required changes in this file.
This file can then be used as input for either the <ctmcreate> utility or the <ctmdefine> utility.
More information on this utility is available in the CONTROL-M/Server Admin Guide.
See also this interesting post
In v6.3 the Mass Update feature is not possible for SET VAR values of Job Definitions.
Suggestion is to use <exportdeftable> or <exportdefjob>
This utilities first export the data from CONTROL-M/Enterprise Manager database to a flat file (xml format)
Then make the required changes from outside of CONTROL-Min in the flat file (by owner script or using text editor like UltraEdit)
The next step is to import the flat file back into the CONTROL-M/Enterprise Manager database using the <deftable> or <defjob> utility.
More information on these utilities is available in the CONTROL-M/EM Utility Guide.
Or use the <ctmexdef> utility
The ctmexdef utility exports job processing definitions from the CONTROL-M/Server database to a flat (ASCII) file.
Then make the required changes in this file.
This file can then be used as input for either the <ctmcreate> utility or the <ctmdefine> utility.
More information on this utility is available in the CONTROL-M/Server Admin Guide.
See also this interesting post
Best regards
Walty
Walty
- rahulsehgal
- Nouveau
- Posts: 148
- Joined: 19 Mar 2009 12:00
- Location: Delhi
- Contact:
HI Walty,
Thanks for your explanations walty. I am aware of exportdeftable and ctmexdef utility for Control-M EM and Control-M Server CLI, but these all jobs are available in drf files, I have to upload all these tables in Control-M/EM and then call them using exportdeftable utility, was just checking if we have anything for Control-M EM Desktop
Thanks for your help and thanks for such good post
Regards,
Rahul Sehgal
Thanks for your explanations walty. I am aware of exportdeftable and ctmexdef utility for Control-M EM and Control-M Server CLI, but these all jobs are available in drf files, I have to upload all these tables in Control-M/EM and then call them using exportdeftable utility, was just checking if we have anything for Control-M EM Desktop
Thanks for your help and thanks for such good post
Regards,
Rahul Sehgal
- Samarth_Vyom
- Nouveau
- Posts: 25
- Joined: 11 Nov 2009 12:00
- rahulsehgal
- Nouveau
- Posts: 148
- Joined: 19 Mar 2009 12:00
- Location: Delhi
- Contact:
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
hy
you can mass upload table in command, what ever is your number version from the em with ecs cli.
So you just have to make the list tables to upload and then run it.
you can make a script like :
DATACEHNTER=<dadacenter>
for ctl in `cat ${listetables}.dat`
do
ecs cli -U <userem> -P <passem> -H <GUI> -TABLE_UPLOAD <DATACENTER> ${ctl} -BY_FORCE
done
regards
philmalmaison
you can mass upload table in command, what ever is your number version from the em with ecs cli.
So you just have to make the list tables to upload and then run it.
you can make a script like :
DATACEHNTER=<dadacenter>
for ctl in `cat ${listetables}.dat`
do
ecs cli -U <userem> -P <passem> -H <GUI> -TABLE_UPLOAD <DATACENTER> ${ctl} -BY_FORCE
done
regards
philmalmaison
- rahulsehgal
- Nouveau
- Posts: 148
- Joined: 19 Mar 2009 12:00
- Location: Delhi
- Contact:
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
- master4usrcm
- Nouveau
- Posts: 12
- Joined: 08 Mar 2010 12:00
- Location: Bangalore India
Hi,
In my case we have some 1000 jobs in Pre-Prod Server DALLAS for which I need to change Auto Edit var and my EM, GUI and Prod server are same(the name is EAST). So I login into Pre-Prod server i,e DALLAS and used ctmexdef to export the table and saved that in XML format and done all the necessary modifications.
Now how should I upload that to Control-M server and EM database.
Can anyone please help me in this??
Thanks & Regards
In my case we have some 1000 jobs in Pre-Prod Server DALLAS for which I need to change Auto Edit var and my EM, GUI and Prod server are same(the name is EAST). So I login into Pre-Prod server i,e DALLAS and used ctmexdef to export the table and saved that in XML format and done all the necessary modifications.
Now how should I upload that to Control-M server and EM database.
Can anyone please help me in this??
Thanks & Regards
The desktop version 6.4, can open draft from 6.3 version.but all the tables are in drf format
So you can:
- use the 6.4 client for update the jobs with the new find and update
- save the new draft in xml file
- import with deftable the draft modified
Or you can save the draft in xml and after modify the xml file as suggested by Walty.