How many times have you needed to make changes to multiple job definitions, like changing a host, or changing the settings on your Agents? Are you aware that you can perform these mass updates easily in your Control-M environment?
If you'd like to learn how to perform these mass updates, we invite you to watch this Connect with Control-M recorded webinar on last Wednesday, October 26th . Cody Belcher demonstrated how to:
• Change Agent parameters in batch
|• Perform job definition updates with EM XML utilities|
|• Update conditions, resources, and host groups in batch|
This is the link on YouTube to the recorded session:
Here is the Q&A for this webinar (Connect with Control-M: Performing Mass Updates In The Control-M Environment)
Q: How do you update the "RunAs" user password without causing jobs to abort? Currently the only way we've found to stop jobs from running is to stop the server but the password can no longer be set from the configuration manager once we do that.
A: In the presentation we demonstrated using the ecaqrtab utility to quiesce jobs, you can also effectively do this with other options such as setting the agent to disabled in the CCM. When you're setting the Run As user password, either run the CCM or the ctmsetown utility you're updating the Control-M/Server so you must have the Control-M/Server up and running.
Q: Does ctmsetown just allow one change/update at a time, or can it use an input file?
A: You can use the action import to import a list of run as accounts with this utility. Running ctmsetown without any arguments will provide you with the syntax of the utility
Q: How do you add additional QR to existing one?
A: To add a Quantitative Resource as a prerequisite on an existing job you and use the find and update tool to add a QR. To add additional resources to a QR, you can use the ecaqrtab utility to set a new max value with a higher value than previously defined.
Q: When using ctm_agparm do we need to recycle the Agent to make the change takes effect? or it depends on the OS?
A: There is no need to recycle the agent and it does not depend on the agent's OS.
Q: Can I add multiple conditions at the same time with ctmcontb?
A: The ctmcontb utility was deigned to add or delete one condition per run, but you can script the running of this utility to processes multiple at once such as from an input file.
Q: Can you use regular expressions in find and update?
A: There are certain field in find and update that do allow regular expressions, such as the replace expression field
Q: How is security (authorization/access) set for the command line utilities for a user or when using API?
A: Since these EM XML utilities connect to a GUI Server to perform these actions, EM Authorizations are applied as normal.
Q: What is the benefit of changing the Order Method by Find and Replace instead of changing it manually?
A: Using find and update allows you to perform the update to multiple folders at once rather than having to change each one individually by hand.
Q: Can we do the same kind of updates for control resources?
A: The ecactltb utility allows you to list the control resources defined in your environment, but you must use the Workload Automation GUI to modify them
Q: Can the EM XML Utilities be executed from both sides, Control-M/EM server or Control-M/EM client?
A: The EM XML Utilities are available on both Control-M/Enterprise Manager Server and Client installs
Q: Can Automation API be used to make mass updates?
A: Automation API does have the ability to make some changes in your environment such as deploying agents and setting up connection profiles
Q: Did the ctmsetown change the password for only one agent or for the runas user authentication settings?
A: The ctmsetown utility changed the password for the single runas account to be used for that agent. You can have the same runas account defined for multiple Agents and the password may need to be updated for each.
Q: How do we add additional OS completion status under on do actions?
A: In the find and update utility you can add or modify an on do action dependent on the OS completion status by adding or updating an On-Do Action -> add/update On Statement -> add/Update Code/Folder End
Q: Can you update the agent authorization list with a mass update?
A: It is not possible to do this with a utility, however, this could be done in batch by running jobs on the Agent to change the parameter locally in the config files or registry. A host group and the 'Run job on all hosts in group' may be handy for this.
Q: What is the best way to mass update job's start time and variable for control-m 8.0?
A: In the find and update utility you can update job's start time using "Update Submission Time: From", this is found in the scheduling -> time settings section
Q: What is the most efficient method (Overhead on Control-M) to stop jobs for a maintenance window on an agent host?
A: In this demonstration we showed multiple ways to stop jobs from submitting, there are additional ways that we didn't cover such as workload policies. Each of these have their own pros and cons but the overhead difference between them is small and choosing which one is best for your environment is dependent on your exact needs
Q: So I should be able to use the Find & Update tool to change the Host/host group name for multiple jobs at one time?
A: Yes, you can use the find and update tool to change the Host or Host Group on multiple jobs at once.
Q: For updating job definitions, is it better to use the command utility or the GUI to update groups of jobs? like - Application or Sub-Application in the job definition.
A: We cannot say that one is better than the other, it depends on which you are most comfortable with.
Q: Is it an issue if you load all folders and do a Find/Update?
A: Each job you load uses memory on the client and the Control-M/Enterprise Manager's GUI Server, loading too many jobs at once could lead to performance degradation, this is one thing to keep in mind when making changes in this way.
Q: Can the Find and Update feature be used to change the domain name of TO, CC, email addresses from one domain name to another like when a company changes names. eg email@example.com to firstname.lastname@example.org? each line has multiple emails
A: Yes, using the replace substring option, you could replace the current domain with the new domain in the given field
Q: How to change the schedule from Everyday to Manual order on the job level only and vice versa using mass update?
A: In the find and update utility, setting Month Days to ALL will set the job to everyday, and setting it the empty will change the job to NONE.
Q: What was the calendar export/import utility and is this available in the Linux installed version. Where can I find detailed information on the utility?
A: The defcal and exportdefcal, as well as the other EM XML utilities are available on a Linux/Unix Control-M/Enterprise Manager. On the tips and tricks slide of the presentation we have a link to the documentation where more detailed usage is covered.
Q: Is it possible to append (add an additional letters to the jobname in either at the start or at the end of the original jobname) using find and update, same things for folder based on the jobs loaded in workspace?
A: Yes, using the replace expression option, entering a $ (dollar symbol) as the expression will add the new value to the end because $ is the regular expression for the end of a string.
Q: Can you please review the "Presets" option in the Find and Update?
A: Presets can be set in the Find & Update tool to store frequently used patterns. To set a preset, fill in either the Find, or both the Find and Update fields and select "Presets" and select "Save".
Q: I would like to backup the Calendars weekly using a batch job. How should I do this?
A: You could schedule a job in Control-M to run either the util or exportdefcal. A 'util -export -type cal' will export ALL calendars, and force you to restore ALL calendars if needed. Using 'exportdefcal', you could be more selective in terms of which calendars you are exporting (via the arguments file) and also more selectively import calendars with defcal, as needed.
Q: How many days of historical data is used for Forecasting?
A: The EM system parameter RunTimeHistoryDays is used. The default value for this parameter is 90.
Q: Is it possible to mass update the Agent's properties under the security option (logon as user specifically) in CCM?
A: It is not possible to do this in the CCM, however, this could be done in batch by running jobs on the Agent to change the parameter locally. A host group and the 'Run job on all hosts in group' may be handy for this.