Running an “Overall” Job with the %RMRUNETL Macro

You can choose to run your staging, aggregation, information map, and reporting jobs within a single processing macro. The staging job is run first. Then the aggregation jobs are run in parallel using Multi-Processing (MP) Connect. Those jobs are followed by the information map jobs that are also run in parallel. Lastly, the report jobs are run in parallel. If the staging job fails, the aggregation, information map, and report jobs are not run. After each job completes, the SAS log is examined by the program. The completion status of the job (Success, Warning, or Error) is sent by email to the specified recipient. If the log displays warnings or errors, the email includes the text of the error or warning along with the corresponding line number in the log file.
Note: To see the results of the job in the tree view, right-click in the left panel and select Refresh.
For information about how to set up the %RMRUNETL macro that provides this ability, see %RMRUNETL.
Note: In the left pane, locate the job that you want to run. Right-click the job’s Properties to specify the scheduling details and authorization requirements of the job that you want to run. If you are running a job in a clustered metadata server environment, make sure that the Enable optional metadata macro variables option is set to No. (In most cases, this option is already set to No.)