{"id":10396,"date":"2016-08-17T15:33:58","date_gmt":"2016-08-17T19:33:58","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=10396"},"modified":"2024-07-22T10:10:51","modified_gmt":"2024-07-22T14:10:51","slug":"running-iri-jobs-in-the-iri-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/","title":{"rendered":"Single Job Execution Options in IRI Workbench"},"content":{"rendered":"<p><a href=\"http:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/a><span style=\"font-weight: 400;\"> not only has several ways to <\/span><a href=\"https:\/\/www.iri.com\/products\/workbench\/design-run-jobs\"><span style=\"font-weight: 400;\">create<\/span><\/a><span style=\"font-weight: 400;\"> jobs, but also several ways to execute them. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">This article focuses on IRI Workbench execution options for job scripts based on the <\/span><a href=\"http:\/\/www.iri.com\/products\/sortcl\"><span style=\"font-weight: 400;\">SortCL<\/span><\/a><span style=\"font-weight: 400;\"> program <\/span><a href=\"http:\/\/www.iri.com\/products\/cosort\/sortcl-metadata\"><span style=\"font-weight: 400;\">language<\/span><\/a><span style=\"font-weight: 400;\">, which covers IRI Voracity ETL, CDC, SDC, pivoting and subsetting jobs, as well as its constituent product functions; i.e., IRI CoSort (transformation and reporting), NextForm (migration and replication), FieldShield (data masking), and RowGen (test data) jobs. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">In addition to IRI Workbench execution, these jobs also run individually on the command line, in a batch script, or as a system call from an executable program. <\/span>See <a href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/\">this article<\/a> for instructions specific to executing batch scripts created in IRI Workbench.<\/p>\n<p><span style=\"font-weight: 400;\">Recall that IRI Workbench is the graphical IDE built on Eclipse that supports all the IRI software products listed above (plus FACT, CellShield EE and DarkShield), and it creates their jobs: 1) manually in a syntax-aware script editor; 2) automatically through end-to-end wizards in the top toolbar menus; or, 3) graphically with the Voracity workflow design palette.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">IRI Workbench also executes other types of jobs, including FACT .ini scripts, DB load utilities, Voracity ETL flow files, DarkShield search and masking jobs, SQL procedures, batch programs, etc. I\u2019ll cover the execution of Voracity flows (which serialize as batch scripts) in my next article.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<h3><b>Locate Your Job(s)<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">When created, these scripts are placed in the active project of the <\/span><b>Project Explorer<\/b><span style=\"font-weight: 400;\">. SortCL job scripts are also created from the Transform Mapping Blocks in a Flow and placed in the active project. In addition, any SortCL script can be copied into a project and then executed.<\/span><\/p>\n<h3><b>Execution Option 1: Command Line<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">IRI jobs run on the command line using the below syntax. The executable for CoSort is sortcl, while the other SortCL language-compatible executables have the same name as the product:<\/span><\/p>\n<pre><b>sortcl <\/b><span style=\"font-weight: 400;\">\/specification=CoSort_transform_or_reporting_job.<\/span><b>scl\r\n<\/b><b>fieldshield <\/b><span style=\"font-weight: 400;\">\/specification=data_masking_job.<\/span><b>fcl<\/b><b>\r\n<\/b><b>nextform <\/b><span style=\"font-weight: 400;\">\/specification=conversion_or_replication_job.<\/span><b>ncl<\/b>\r\n<b>rowgen <\/b><span style=\"font-weight: 400;\">\/specification=test_data_generation_job.<\/span><b>rcl<\/b><\/pre>\n<p><span style=\"font-weight: 400;\">The IRI job script can be moved to any computer where an IRI executable is installed. The script can be run from a command line or from within a batch process, and the same script can be executed on computers with Windows, Linux, and Unix operating systems. Therefore, it is possible to develop a script on your desktop, then move it to another computer for execution.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You can also invoke a shell user interface from within IRI Workbench to gain access to a command line prompt. This can be done using \u00a0<\/span><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/external-tools-for-iri-workbench\/\"><span style=\"font-weight: 400;\">ShelExec<\/span><\/a><span style=\"font-weight: 400;\">, <\/span><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/wicked-shell-in-the-iri-workbench\/\"><span style=\"font-weight: 400;\">Wicked Shell<\/span><\/a><span style=\"font-weight: 400;\">, or the <\/span><a href=\"http:\/\/help.eclipse.org\/kepler\/index.jsp?topic=%2Forg.eclipse.rse.doc.user%2Ftasks%2Ftruncmdsview.html\"><span style=\"font-weight: 400;\">Launch Shell<\/span><\/a><span style=\"font-weight: 400;\"> feature in the Remote Systems Explorer.\u00a0<\/span><b>\f<\/b><\/p>\n<h3><b>Execution Option 2: Run Menu<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">You can execute a valid job script by clicking on the white arrow in the green circle on the navigation bar. This is the <\/span><b>Run<\/b><span style=\"font-weight: 400;\"> menu item and will only execute after you first click on a script in a project, or you click in the body of a script in the editor. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you click the down arrow next to <\/span><b>Run<\/b><span style=\"font-weight: 400;\">, a list of scripts that were previously run is shown. Click any script on that list to execute it. In addition to the list of scripts, you can also select <\/span><b>Run As<\/b><span style=\"font-weight: 400;\"> &gt; <\/span><b>IRI Job<\/b><span style=\"font-weight: 400;\"> to run the active script.<\/span><\/p>\n<h3><b>Execution Option 3: Run As<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Suppose we want to execute the script SortTransSelect.scl located in the project MonthEnd. To execute from the <\/span><b>Project Explorer<\/b><span style=\"font-weight: 400;\">, right-click on the script name and click &gt; <\/span><b>Run As<\/b><span style=\"font-weight: 400;\"> &gt; <\/span><b>IRI Job<\/b><span style=\"font-weight: 400;\">. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Otherwise, if the script is the active tab in the editor, right-click in the body of the script and click &gt; <\/span><b>Run As<\/b><span style=\"font-weight: 400;\"> &gt; <\/span><b>IRI Job<\/b><span style=\"font-weight: 400;\">. Both \u00a0methods will execute a script and place results in the project.<\/span><\/p>\n<h3><b>Execution Option 4: Local Run Configurations<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">In each of the above cases, you can choose <\/span><b>Run Configurations<\/b><span style=\"font-weight: 400;\"> instead of <\/span><b>IRI Job<\/b><span style=\"font-weight: 400;\">. Every time you execute a SortCL script, the information about the job is recorded on the <strong>R<\/strong><\/span><b>un Configurations<\/b><span style=\"font-weight: 400;\"> window. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">In the box to the left under <\/span><b>IRI job<\/b><span style=\"font-weight: 400;\"> are the names for the jobs that have been previously defined or run. \u00a0Initially, the name of the job is the name of the SortCL job script.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"> In this case, we select SortTransSelect.scl. If no jobs have been set up, or to set up a new job, right-click <\/span><b>IRI Job<\/b><span style=\"font-weight: 400;\"> and click <\/span><b>New<\/b><span style=\"font-weight: 400;\">. New_configuration will be in the <\/span><b>Name <\/b><span style=\"font-weight: 400;\">field and placed under <\/span><b>IRI Job<\/b><span style=\"font-weight: 400;\"> in the tree.<\/span><\/p>\n<h3><b>The Main Tab<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">In the screenshot below, we have MonthEnd in the <\/span><b>Project<\/b><span style=\"font-weight: 400;\"> field of the <\/span><b>Main<\/b><span style=\"font-weight: 400;\"> tab. The SortTransSelect.scl script is listed in the <\/span><b>Job Execution Sequence<\/b><span style=\"font-weight: 400;\"> box with the project name and path where the script is located. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">The <\/span><b>IRI Executable <\/b><span style=\"font-weight: 400;\">f<\/span><b>ield<\/b><span style=\"font-weight: 400;\"> contains the path and name for the executable used with this job. \u00a0You can select a different executable from the drop-down or <\/span><b>Browse<\/b><span style=\"font-weight: 400;\"> to one.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/1-Run-Configurations.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10397\" title=\"Run Configurations\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/1-Run-Configurations.png\" alt=\"Run Configurations\" width=\"600\" height=\"454\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/1-Run-Configurations.png 624w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/1-Run-Configurations-300x227.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">You can list multiple job scripts in the <\/span><b>Job Execution Sequence<\/b><span style=\"font-weight: 400;\"> box. Select<\/span><b> Search\/Add <\/b><span style=\"font-weight: 400;\">to bring up the<\/span><b> Select SortCL job files<\/b><span style=\"font-weight: 400;\"> window, which lists all the SortCL language scripts located in the project. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">The check box for SortTransSelect.scl is already selected. Now select the check box for join.scl and click <\/span><b>OK<\/b><span style=\"font-weight: 400;\">. The two SortCL scripts are now listed in alphabetical order in the <\/span><b>Job Execution Sequence<\/b><span style=\"font-weight: 400;\"> box. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">The scripts will be executed in the order they are listed. Since we want join.scl to execute last, click it and select <\/span><b>Down<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/2-Select-SortCL-job-files.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10398 size-full\" title=\"Select SortCL job files\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/2-Select-SortCL-job-files.png\" alt=\"Select SortCL job files\" width=\"359\" height=\"322\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/2-Select-SortCL-job-files.png 359w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/2-Select-SortCL-job-files-300x269.png 300w\" sizes=\"(max-width: 359px) 100vw, 359px\" \/><\/a><\/p>\n<h3><b>Defining Environment Variables<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">In the job script SortTransSelect.scl, there is a line in the script like this one:<\/span><\/p>\n<pre><b>\/QUERY<\/b><span style=\"font-weight: 400;\">=\"SELECT * FROM NIGHTLY.TRANSACTIONS WHERE PURCHASE_DATE &gt;= \\'\\$STARTDATE\\' AND PURCHASE_DATE &lt; \\$ENDDATE\\'\"<\/span><\/pre>\n<p><span style=\"font-weight: 400;\">There are two environment variables: STARTDATE and ENDDATE. In the <\/span><b>Environment Variables<\/b><span style=\"font-weight: 400;\"> tab, you can define any that are used in the job scripts. Select <\/span><b>New <\/b><span style=\"font-weight: 400;\">to specify each one. For the first, enter \u201cSTARTDATE\u201d for <\/span><b>Name<\/b><span style=\"font-weight: 400;\"> and \u201c161201\u201d for <\/span><b>Value<\/b><span style=\"font-weight: 400;\">. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">For the second, enter \u201cENDDATE\u201d for <\/span><b>Name<\/b><span style=\"font-weight: 400;\"> and \u201c170101\u201d for <\/span><b>Value<\/b><span style=\"font-weight: 400;\">. Both are then listed in the box for <\/span><b>Environment variables to set<\/b><span style=\"font-weight: 400;\">. Make sure <\/span><b>Append environment to native environment<\/b><span style=\"font-weight: 400;\"> is selected.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/3-New-Environment-Variable.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10399\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/3-New-Environment-Variable.png\" alt=\"New Environment Variable\" width=\"390\" height=\"160\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/3-New-Environment-Variable.png 390w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/3-New-Environment-Variable-300x123.png 300w\" sizes=\"(max-width: 390px) 100vw, 390px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/4-Run-Configurations-EV.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10400\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/4-Run-Configurations-EV.png\" alt=\"Run Configurations-Environment Variables\" width=\"600\" height=\"454\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/4-Run-Configurations-EV.png 624w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/4-Run-Configurations-EV-300x227.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<h3><b><br \/>\nSaving and Running the Job<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Since we are executing two SortCL job scripts, we should rename the jobs (from <\/span><b>Name<\/b><span style=\"font-weight: 400;\">) to something more appropriate. Change it to MonthendPart1 and click <\/span><b>Apply<\/b><span style=\"font-weight: 400;\">. In the tree on the left, the name for <\/span><b>IRI Job<\/b><span style=\"font-weight: 400;\"> changes from SortTransSelect.scl to MonthEndPart1, and all the other changes made are saved.<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10401\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png\" alt=\"Run Configurations-Main\" width=\"600\" height=\"480\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png 624w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main-300x240.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Whenever you want to execute this job, access <\/span><b>Run Configurations<\/b><span style=\"font-weight: 400;\">, click MonthEndPart1 in the tree, and click <\/span><b>Run<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h3><b>Execution Option 5: Remote Run Configurations<\/b><\/h3>\n<p>Jobs in projects on remote systems\u00a0can also launch from your <b>Run Configurations <\/b>dialog in IRI Workbench. In this case, I have a remote project called Force5Project1 on a Linux server called Force5 which contains a SortCL job script called chiefs_sep.scl. Type Force5SortChiefs in the <b>Name <\/b>field.<\/p>\n<h3><b>The Main Tab<\/b><\/h3>\n<p>The <b>Project <\/b>field should be Force5Project1.\u00a0Select the <b>Search\/Add<\/b> button, then select the check box for our script. Click <b>OK<\/b> to populate the <b>Job Execution Sequence<\/b> box.<\/p>\n<p>When the project was select, the IRI Executable drop down was populated with the products located on the remote server associated with the project. Select\u00a0the executable starting with\u00a0<strong>rse:\/\/FORCE5<\/strong>. The working directory was populated with the location on the remote server associated with the project.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2018\/10\/RemoteRun.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12450\" src=\"\/blog\/wp-content\/uploads\/2018\/10\/RemoteRun.png\" alt=\"\" width=\"600\" height=\"393\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/10\/RemoteRun.png 1010w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/10\/RemoteRun-300x196.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2018\/10\/RemoteRun-768x503.png 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<h3><b>Conclusion<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">There are multiple ways to execute an individual job script in the IRI Workbench, and there are several ways to access both <\/span><b>Run <\/b><span style=\"font-weight: 400;\">and <\/span><b>Run As <\/b><span style=\"font-weight: 400;\">for a particular script. In addition, the <\/span><b>Run Configurations<\/b><span style=\"font-weight: 400;\"> window offers a way to set up and save the parameters for both local and remote jobs, allowing repetition of the jobs to be consistent. Any messages associated with a job display in the <\/span><b>Console <\/b><span style=\"font-weight: 400;\">view at runtime.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>IRI Workbench not only has several ways to create jobs, but also several ways to execute them. This article focuses on IRI Workbench execution options for job scripts based on the SortCL program language, which covers IRI Voracity ETL, CDC, SDC, pivoting and subsetting jobs, as well as its constituent product functions; i.e., IRI CoSort<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/\" title=\"Single Job Execution Options in IRI Workbench\">Read More<\/a><\/div>\n","protected":false},"author":10,"featured_media":10401,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[32,8,31,363,1,776,91],"tags":[950,71,1157,546,520,553,526,850,1160,517,1158,447,302,928,1150,68,88,627,1159],"class_list":["post-10396","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-data-protection","category-data-migration","category-data-quality","category-data-transformation2","category-etl","category-iri-workbench","tag-classify","tag-eclipse","tag-execution-options","tag-iri-cosort","tag-iri-fieldshield","tag-iri-nextform","tag-iri-rowgen","tag-iri-workbench","tag-launch-shell","tag-mask","tag-migrate","tag-replicate","tag-report","tag-scripts","tag-shelexec","tag-sortcl","tag-test-data-2","tag-transform","tag-wickedshell"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Single Job Execution Options in IRI Workbench - IRI<\/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.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Single Job Execution Options in IRI Workbench\" \/>\n<meta property=\"og:description\" content=\"IRI Workbench not only has several ways to create jobs, but also several ways to execute them. This article focuses on IRI Workbench execution options for job scripts based on the SortCL program language, which covers IRI Voracity ETL, CDC, SDC, pivoting and subsetting jobs, as well as its constituent product functions; i.e., IRI CoSortRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2016-08-17T19:33:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-22T14:10:51+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png\" \/>\n\t<meta property=\"og:image:width\" content=\"624\" \/>\n\t<meta property=\"og:image:height\" content=\"499\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Susan Gegner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Susan Gegner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/\"},\"author\":{\"name\":\"Susan Gegner\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\"},\"headline\":\"Single Job Execution Options in IRI Workbench\",\"datePublished\":\"2016-08-17T19:33:58+00:00\",\"dateModified\":\"2024-07-22T14:10:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/\"},\"wordCount\":1249,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png\",\"keywords\":[\"classify\",\"Eclipse\",\"execution options\",\"IRI CoSort\",\"IRI FieldShield\",\"IRI NextForm\",\"IRI RowGen\",\"IRI Workbench\",\"Launch Shell\",\"mask\",\"migrate\",\"replicate\",\"report\",\"scripts\",\"ShelExec\",\"SortCL\",\"test data\",\"transform\",\"WickedShell\"],\"articleSection\":[\"Business Intelligence (BI&#041;\",\"Data Masking\/Protection\",\"Data Migration\",\"Data Quality (DQ&#041;\",\"Data Transformation\",\"ETL\",\"IRI Workbench\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/\",\"name\":\"Single Job Execution Options in IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png\",\"datePublished\":\"2016-08-17T19:33:58+00:00\",\"dateModified\":\"2024-07-22T14:10:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png\",\"width\":624,\"height\":499,\"caption\":\"Run Configurations-Main\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Single Job Execution Options in IRI Workbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\",\"name\":\"Susan Gegner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"caption\":\"Susan Gegner\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/susang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Single Job Execution Options in IRI Workbench - IRI","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.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Single Job Execution Options in IRI Workbench","og_description":"IRI Workbench not only has several ways to create jobs, but also several ways to execute them. This article focuses on IRI Workbench execution options for job scripts based on the SortCL program language, which covers IRI Voracity ETL, CDC, SDC, pivoting and subsetting jobs, as well as its constituent product functions; i.e., IRI CoSortRead More","og_url":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/","og_site_name":"IRI","article_published_time":"2016-08-17T19:33:58+00:00","article_modified_time":"2024-07-22T14:10:51+00:00","og_image":[{"width":624,"height":499,"url":"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png","type":"image\/png"}],"author":"Susan Gegner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Susan Gegner","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/"},"author":{"name":"Susan Gegner","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63"},"headline":"Single Job Execution Options in IRI Workbench","datePublished":"2016-08-17T19:33:58+00:00","dateModified":"2024-07-22T14:10:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/"},"wordCount":1249,"commentCount":1,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png","keywords":["classify","Eclipse","execution options","IRI CoSort","IRI FieldShield","IRI NextForm","IRI RowGen","IRI Workbench","Launch Shell","mask","migrate","replicate","report","scripts","ShelExec","SortCL","test data","transform","WickedShell"],"articleSection":["Business Intelligence (BI&#041;","Data Masking\/Protection","Data Migration","Data Quality (DQ&#041;","Data Transformation","ETL","IRI Workbench"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/","url":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/","name":"Single Job Execution Options in IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png","datePublished":"2016-08-17T19:33:58+00:00","dateModified":"2024-07-22T14:10:51+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png","width":624,"height":499,"caption":"Run Configurations-Main"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Single Job Execution Options in IRI Workbench"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63","name":"Susan Gegner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","caption":"Susan Gegner"},"url":"https:\/\/www.iri.com\/blog\/author\/susang\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/08\/5-Run-Configurations-Main.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10396"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=10396"}],"version-history":[{"count":20,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10396\/revisions"}],"predecessor-version":[{"id":17803,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10396\/revisions\/17803"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/10401"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=10396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=10396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=10396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}