{"id":13529,"date":"2020-03-03T09:51:15","date_gmt":"2020-03-03T08:51:15","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/"},"modified":"2020-03-03T09:51:15","modified_gmt":"2020-03-03T08:51:15","slug":"control-m-em-mass-update-some-example-on-how-to-use-it","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/","title":{"rendered":"Control-M\/EM Mass update,some examples on how to use it"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>We are back today to write about a powerful tool that we can use to update our folders<\/p>\n<h3>Question<\/h3>\n<p>Suppose you have to update two jobs of your folder; the task should be easy<\/p>\n<p>But what happens when you must update 50 jobs in a restricted delay?<\/p>\n<h3>Solution<\/h3>\n<p>To get this easier and smarter we will use the find and update tool<\/p>\n<p>We will use the find and update tool<\/p>\n<ul style=\"list-style-type: disc\">\n<li>To find specifics jobs<\/li>\n<li>To find specific commands<\/li>\n<li>To find specific users<\/li>\n<li>To update jobs with new parameters<\/li>\n<\/ul>\n<p>Before going further, we will list the methods to find information\u2019s in Control M folders<\/p>\n<p>We have many ways to get information about our folders<\/p>\n<ol>\n<li>By using The SQL queries<\/li>\n<li>By using The XML export<\/li>\n<li>By using The find and update method<\/li>\n<\/ol>\n<p>Depending of the need, you can use the three methods as well knowing that they are the result of SQL queries<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS23.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37816\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS23.jpg\" alt=\"\" width=\"1186\" height=\"758\" \/><\/a><\/p>\n<h2>Using the find and update option<\/h2>\n<p>First of all, we have to connect on CTM GUI and go to the planning panel to check job definitions<\/p>\n<p>We will select the folder where we will have to perform the task<\/p>\n<p>Then we will use the find and update button<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37791\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg\" alt=\"\" width=\"1916\" height=\"212\" \/><\/a><\/p>\n<p>We will check how many jobs contain the word TEST in their name<\/p>\n<p><strong><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37792\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS2.png\" alt=\"\" width=\"844\" height=\"867\" \/><\/a><\/strong><\/p>\n<p><u>Result:<\/u><\/p>\n<p>We found 12 jobs corresponding to these criteria<\/p>\n<p>Now supposing we want to list and update only a certain type of job for example OS jobs, excluding MFT jobs and dummy jobs<\/p>\n<p>We select JOB\/Folder Type in the huge drop down panel and enter the type requested ( here *OS* for OS JOB )<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS3-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37824\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS3-1.png\" alt=\"\" width=\"740\" height=\"801\" \/><\/a><\/p>\n<p><u>Note:<\/u><\/p>\n<p>As explained at the beginning of the blog this searching tool is based on <strong>SQL queries<\/strong>, it only gives us a more \u201cfriendly\u201d way to perform our queries<\/p>\n<p>When we launch the search we have 10 jobs corresponding to OS jobs and containing TEST is their name<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS5-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37826\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS5-1.png\" alt=\"\" width=\"754\" height=\"769\" \/><\/a><\/p>\n<p>Now you know the principle, we can proceed to any update of these jobs depending of your request<\/p>\n<p>For example, let\u2019s try to update the jobs by assigning them a Quantitative resource<\/p>\n<p>First step is to make a \u201cbackup\u201d of our folder<\/p>\n<p>Easiest way to do that is to make a <strong>xml export file<\/strong> (that is also a good way to search information\u2019s about your folder)<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS6-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37842\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS6-1.png\" alt=\"\" width=\"821\" height=\"156\" \/><\/a><\/p>\n<p>Once your save done, we can proceed to QR adding<\/p>\n<p>We will assign a QR for each jobs containing TEST in their name<\/p>\n<p><u>Important<\/u><\/p>\n<p>Ensure you have clicked on the <strong>checkout<\/strong> button to update your jobs:<\/p>\n<p>Select in update part the function you want to assign or update and enter the character chain you want to apply it for your select jobs<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37800\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS10.png\" alt=\"\" width=\"855\" height=\"436\" \/><\/a><\/p>\n<p>After the jobs update you can check them to see if the update is corresponding to what you expect<\/p>\n<p>If it&#8217;s not the case, you can perform a <em>Rollback Updates<\/em> command.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37801\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS11.png\" alt=\"\" width=\"855\" height=\"556\" \/><\/a><\/p>\n<p>Let\u2019s open a job and see if QR update worked.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS12.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37802\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS12.png\" alt=\"\" width=\"853\" height=\"458\" \/><\/a><\/p>\n<p>Update worked well as we see in prerequisite tab, we can also see that no quantity is defined nor total Amount (which must be defined in the QR definitions tab, maybe in a new blog in coming)<\/p>\n<p>So what about adding this quantity to each job? \ud83d\ude00<\/p>\n<p><strong><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37803\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS13.png\" alt=\"\" width=\"822\" height=\"636\" \/><\/a><\/strong><\/p>\n<p>After that we have to check if jobs are configured as expected<\/p>\n<p><strong>Watch out !<\/strong><\/p>\n<p>If you want to add QR by mass update be careful to add your quantity in the same command to avoid adding twice a time a QR<\/p>\n<p>Example<\/p>\n<p>If you repeat the update above , it will be incremented so you will find two identical QR in a same job and you would get this kind of result<\/p>\n<p><strong><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS16-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37853\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS16-1.png\" alt=\"\" width=\"823\" height=\"332\" \/><\/a><\/strong><\/p>\n<p>So make sure you double check you updates and if possible do the update in a single row like below<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS14-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37849\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS14-1.png\" alt=\"\" width=\"811\" height=\"616\" \/><\/a><\/p>\n<p>After your update don\u2019t forget to do your check-in &#x1f609;<\/p>\n<h2>Tip:Save and load presets<\/h2>\n<p>Last time I did a tricky query, but I forgot how did I achieved to have the result I was expecting for\u2026So instead of searching like me during hours to find it,what about doing some presets of our favorites or our more complicated requests?<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS16_1-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37859\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS16_1-1.png\" alt=\"\" width=\"717\" height=\"428\" \/><\/a><\/p>\n<p>Select the Presets button than save your preset ( the drop down panel show also the other saved presets)<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS16_2-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37861\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS16_2-1.png\" alt=\"\" width=\"714\" height=\"433\" \/><\/a><\/p>\n<p>That&#8217;s it , you will no longer blame your old age for having forgotten how to sort our jobs&#8230;<\/p>\n<h2>Update jobs by editing XML file or Jobs &amp; Folders file Editor<\/h2>\n<h3>Update from XML file<\/h3>\n<p>You can also update your jobs by exporting the corresponding xml file (as for our previous folder backup)<\/p>\n<p>In the planning tab you select the folder that you want to export, then once exported you can edit it with your favorite file editor<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS-NOTEPADUPDATE2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37820\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS-NOTEPADUPDATE2.png\" alt=\"\" width=\"902\" height=\"520\" \/><\/a><\/p>\n<p>It\u2019s a quick way to identify jobs and other components of your folder such as hostnames, conditions or variables<\/p>\n<p>Once your fields updated you import the file in the planning then you can upload it<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS18.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37810\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS18.jpg\" alt=\"\" width=\"1214\" height=\"253\" \/><\/a><\/p>\n<p>But there is a constraint:<\/p>\n<p><strong>You can\u2019t keep the modification&#8217;s history<\/strong> of your folder if you upload it from an xml file,as control will consider it as a brand new folder.<\/p>\n<h3>Update with Jobs &amp; Folders file Editor tool:<\/h3>\n<p>You can also use the Jobs &amp; Folders file Editor which is a tool mixing XML file and graphical interface for your jobs:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS17.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37809\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS17.jpg\" alt=\"\" width=\"1216\" height=\"227\" \/><\/a><\/p>\n<p>Load the XML file you want to update:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS18_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37811\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS18_2.png\" alt=\"\" width=\"754\" height=\"566\" \/><\/a><\/p>\n<p>After your modifications you can save it:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS19-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37827\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS19-1.png\" alt=\"\" width=\"900\" height=\"348\" \/><\/a><\/p>\n<p>Then you can upload the XML file.<\/p>\n<p>This tool let you have a better translation and understanding of your XML file in a Control M folder display format<\/p>\n<p><u>Reminder:<\/u><\/p>\n<p>The result is the same as updating with XML file in other terms <strong>you will not be able to keep your folder\u2019s history<\/strong>.<\/p>\n<h2>Using SQL queries :<\/h2>\n<p>This method is the basic method and the modification on the database doesn\u2019t need a \u201ccheckout check-in\u201d process<\/p>\n<p>In the following examples we will check how to update jobs through SQL queries and see the result on the planning<\/p>\n<p>We will use the table below to update our jobs and check if they are taken in account in control M planning<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS22.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37815\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS22.jpg\" alt=\"\" width=\"368\" height=\"469\" \/><\/a><\/p>\n<p>You can get the Control M DB schema following this link to process your requests:<\/p>\n<p><a href=\"ftp:\/\/ftp.bmc.com\/pub\/control-m\/opensystem\/DB_Schemas\/918_ERDs\/Control-M_9.0.18_DB_Ports_Diagram.zip\">ftp:\/\/ftp.bmc.com\/pub\/control-m\/opensystem\/DB_Schemas\/918_ERDs\/Control-M_9.0.18_DB_Ports_Diagram.zip<\/a><\/p>\n<p>Connect on user control and type SQL to get the prompt:<\/p>\n<p><u>Constraint<\/u><\/p>\n<p>You need to know the name of the table to do your update and of course the associated command.<\/p>\n<p>If you have no SQL skills it could be better to use <em>find and update<\/em> graphical tool.<\/p>\n<p>The below example will show us how to update a jobname with PostgreSQL command:<\/p>\n<ul style=\"list-style-type: square\">\n<li>\n<h3>List the jobs by SQL query<\/h3>\n<\/li>\n<\/ul>\n<p>First we will list the jobs defined in the folder:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">ctmem=&gt; select job_name,application from def_ver_job where application like 'MFTAPPLICATION' ;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 job_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0 application\n------------------------------------+----------------\n\u00a0JOB_TEST_CR3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0JOB_TEST_PGADMIN_re\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0      | MFTAPPLICATION\n\u00a0JOB_TEST_CR2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0| MFTAPPLICATION\n\u00a0JOB_TEST_CR6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0FileWatcher_Job\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0JOB_TEST_SHOUT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0FileWatcher_Job1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0JOB_TEST_CR5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| MFTAPPLICATION\n\u00a0JOB_TEST_CR4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0JOB_TEST\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0JOB_TEST_SHOUT2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0MFT_TRANSFERT_CENT_TO_SRVCTM3\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0MFT_TRANSFERT_CENT_TO_SRVCTM4\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0MFT_TRANSFERT_CENT_TO_SRVCTM1\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0JOB_TEST_CR1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0JOB_TEST_PGADMIN_updated\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| MFTAPPLICATION\n\u00a0MFT_TRANSFERT_TEST_CENT_TO_SRVCTM2 | MFTAPPLICATION\n\u00a0TEST_DUMMY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n(18 rows)<\/pre>\n<ul style=\"list-style-type: square\">\n<li>\n<h3>Update and verification on PostgreSQL<\/h3>\n<\/li>\n<\/ul>\n<p>We will update the jobname and check if the update worked<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">ctmem=&gt;\nctmem=&gt; update def_ver_job set job_name='JOB_TEST_PGADMIN_updated' where job_name like 'JOB_TEST_PGADMIN_ re ' ;\nUPDATE 2\nctmem=&gt; select job_name from def_ver_job where job_name like 'JOB_TEST%' and application like 'MFT%' ;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 job_name\n--------------------------\n\u00a0JOB_TEST_CR3\n\u00a0JOB_TEST_PGADMIN_updated\n\u00a0JOB_TEST_CR2\n\u00a0JOB_TEST_CR6\n\u00a0JOB_TEST_SHOUT\n\u00a0JOB_TEST_CR5\n\u00a0JOB_TEST_CR4\n\u00a0JOB_TEST\n\u00a0JOB_TEST_SHOUT2\n\u00a0JOB_TEST_CR1\n\u00a0JOB_TEST_PGADMIN_updated\n(11 rows)\n\u00a0\nctmem=&gt;<\/pre>\n<ul style=\"list-style-type: square\">\n<li>\n<h3>Verification on the control M GUI planning panel<\/h3>\n<\/li>\n<\/ul>\n<p>It\u2019s taken in account in the planning (you must quit your workspace and reload it , no need to log off)<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS23-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-37835\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS23-1.jpg\" alt=\"\" width=\"1186\" height=\"758\" \/><\/a><\/p>\n<p><strong>Now we want to repeat this action on many jobs<\/strong><\/p>\n<p>Let\u2019s try to update the \u2018run as\u2019 part of every job running as controlm user and compare it to the find and update graphical method<\/p>\n<p>First we have to identify the column corresponding to the \u2018run as\u2019 in dbschema , it matches with &#8216;owner&#8217; parameter<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">ctmem=&gt; select owner,job_name,application from def_ver_job where application like 'MFTAPPLICATION' ;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 owner\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 job_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0 application\n--------------------+------------------------------------+----------------\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_PGADMIN_updated\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0| JOB_TEST_CR6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | FileWatcher_Job\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_SHOUT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | FileWatcher_Job1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0NABIL_MFT_2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFT_TRANSFERT_CENT_TO_SRVCTM3\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0CMT_NABIL_EXPORTED | MFT_TRANSFERT_CENT_TO_SRVCTM4\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_SHOUT2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0NABIL_MFT_2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFT_TRANSFERT_CENT_TO_SRVCTM1\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0controlm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_PGADMIN_updated\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0CMT_NABIL_EXPORTED | MFT_TRANSFERT_TEST_CENT_TO_SRVCTM2 | MFTAPPLICATION\n\u00a0DUMMYUSR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | TEST_DUMMY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n(18 rows)<\/pre>\n<p>Now we have listed all the users of my folder we can update the \u2018run as\u2019 parameter to modify from controlm \u2018run as user\u2019 to emuser<\/p>\n<h2>Find jobs to modify on control M GUI<\/h2>\n<p>We make a find and update to list the jobs running with user controlm then we will update them by PostgreSQL query (don&#8217;t use the update button we will do this update through PostgreSQL query just below to get the same result \ud83d\ude09 )<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS21-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37834\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS21-1.png\" alt=\"\" width=\"860\" height=\"875\" \/><\/a><\/p>\n<h2>Mass update the jobs from SQL query<\/h2>\n<p>We will perform the update by sql query and check if it is taken in account on Control M GUI<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">ctmem=&gt; update def_ver_job set owner='emuser' where owner like 'controlm' and application like 'MFTAPPLICATION' ;\nUPDATE 13\nctmem=&gt;<\/pre>\n<p>Then we can list again if run as update worked:<\/p>\n<h3>Checking with PostgreSQL query<\/h3>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">ctmem=&gt; select owner,job_name,application from def_ver_job where application like 'MFTAPPLICATION' ;\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 owner\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 job_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0 application\n--------------------+------------------------------------+----------------\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_PGADMIN_updated\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR6\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | FileWatcher_Job\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_SHOUT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | FileWatcher_Job1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_SHOUT2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0NABIL_MFT_2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFT_TRANSFERT_CENT_TO_SRVCTM3\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0CMT_NABIL_EXPORTED | MFT_TRANSFERT_CENT_TO_SRVCTM4\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0NABIL_MFT_2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFT_TRANSFERT_CENT_TO_SRVCTM1\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_CR1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0emuser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | JOB_TEST_PGADMIN_updated\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n\u00a0CMT_NABIL_EXPORTED | MFT_TRANSFERT_TEST_CENT_TO_SRVCTM2 | MFTAPPLICATION\n\u00a0DUMMYUSR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | TEST_DUMMY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | MFTAPPLICATION\n(18 rows)\n\u00a0\nctmem=&gt;<\/pre>\n<h3>Checking from GUI find and update method<\/h3>\n<p>By checking on the GUI we see Run as user is now updated , the owner <em>emuser<\/em> is now assigned as &#8216;run as&#8217; to the 12 jobs ,they were updated, furthermore we didn\u2019t see any <em>controlm<\/em> user in the search:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS24-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37836\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS24-1.png\" alt=\"\" width=\"828\" height=\"851\" \/><\/a><\/p>\n<p>As a result , we can see that the check of run as user <em>controlm<\/em> return no match.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS25.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37818\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS25.png\" alt=\"\" width=\"913\" height=\"569\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Using SQL query is a powerful\u00a0 tool to do the mass update but it is more friendly to use find and update tool , because it is easier for you to do a \u00a0rollback update \u00a0and also find the rows you want to update without consulting the Control M dbschema which be a bit less intuitive.<\/p>\n<p>To make a quick review of the the main solutions here&#8217;s a quick summary of good and bad points of each of them:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS26.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-37872\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS26.png\" alt=\"\" width=\"1221\" height=\"415\" \/><\/a><\/p>\n<p>And you, which method would you chose?<\/p>\n<h2>Conclusion<\/h2>\n<p>Now you know how to perform your updates on your Control M\u2019s folders, naturally \u00a0you can choose the most adapted solution depending of your need.<\/p>\n<p>Be careful to always have a backup of your folders before doing your update and feel free to give other tips or tricks in the comment part.<\/p>\n<p>Once again you can check my\u00a0<a href=\"https:\/\/www.dbi-services.com\/bloggers\/\"> dbi colleagues blogs<\/a> concerning Control M and other technologies and of course see you for a next session \ud83d\ude00<\/p>\n<p>You also have the possibility to check BMC site and their excellent videos.<\/p>\n<p>By the way,to avoid any influence I prefer to do my topic before checking if any similar is existing on this site or elsewhere,then I can compare if we have the same methodology and way to use Control M\u00a0 :D.<\/p>\n<p>Also feel free to check my other blogs and don&#8217;t hesitate to share your advice on it ;).<\/p>\n<p>Another example on how to use Mass update, I told you it&#8217;s a really cool tool !<\/p>\n<p><iframe loading=\"lazy\" title=\"How to add an ON STATEMENT\/CODE via Find &amp; Update\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/cjVh45z1N0Y?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction We are back today to write about a powerful tool that we can use to update our folders Question Suppose you have to update two jobs of your folder; the task should be easy But what happens when you must update 50 jobs in a restricted delay? Solution To get this easier and smarter [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":13531,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1256,83],"tags":[],"type_dbi":[],"class_list":["post-13529","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-control-m","category-postgresql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Control-M\/EM Mass update,some examples on how to use it - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Control-M\/EM Mass update,some examples on how to use it\" \/>\n<meta property=\"og:description\" content=\"Introduction We are back today to write about a powerful tool that we can use to update our folders Question Suppose you have to update two jobs of your folder; the task should be easy But what happens when you must update 50 jobs in a restricted delay? Solution To get this easier and smarter [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-03T08:51:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1916\" \/>\n\t<meta property=\"og:image:height\" content=\"212\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Middleware Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Middleware Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"Control-M\/EM Mass update,some examples on how to use it\",\"datePublished\":\"2020-03-03T08:51:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/\"},\"wordCount\":1684,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg\",\"articleSection\":[\"Control-M\",\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/\",\"name\":\"Control-M\/EM Mass update,some examples on how to use it - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg\",\"datePublished\":\"2020-03-03T08:51:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg\",\"width\":1916,\"height\":212},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Control-M\/EM Mass update,some examples on how to use it\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\",\"name\":\"Middleware Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"caption\":\"Middleware Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Control-M\/EM Mass update,some examples on how to use it - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/","og_locale":"en_US","og_type":"article","og_title":"Control-M\/EM Mass update,some examples on how to use it","og_description":"Introduction We are back today to write about a powerful tool that we can use to update our folders Question Suppose you have to update two jobs of your folder; the task should be easy But what happens when you must update 50 jobs in a restricted delay? Solution To get this easier and smarter [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/","og_site_name":"dbi Blog","article_published_time":"2020-03-03T08:51:15+00:00","og_image":[{"width":1916,"height":212,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg","type":"image\/jpeg"}],"author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"Control-M\/EM Mass update,some examples on how to use it","datePublished":"2020-03-03T08:51:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/"},"wordCount":1684,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg","articleSection":["Control-M","PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/","url":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/","name":"Control-M\/EM Mass update,some examples on how to use it - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg","datePublished":"2020-03-03T08:51:15+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MASS1.jpg","width":1916,"height":212},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/control-m-em-mass-update-some-example-on-how-to-use-it\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Control-M\/EM Mass update,some examples on how to use it"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1","name":"Middleware Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","caption":"Middleware Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=13529"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13529\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/13531"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13529"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}