topic Re: How to execute a SAS job through Control M ? in SAS Programming

How to execute a SAS job through Control M ?

Rixile106 — Thu, 18 Aug 2022 10:22:28 GMT

good day,

am trying to execute sas jobs through controlM .any idea how i can achieve this. below is my library name

/SAS/data/RiskDataManagement/data/NWOW/data/VBM/ControlM/DatatoHiveScripts.sas

Re: How to execute a SAS job through Control M ?

LinusH — Thu, 18 Aug 2022 12:10:56 GMT

If you have a SAS Metadata Server, and have deployed jobs from e.g. Data Integration Studio, you can get the full command line for each job in the deployed jobs properties in SAS Management Console.

Another option is to schedul flow of SAS jobs in SAS for host operation system scheduler. That will creata a .bat/.sh script which you can call from CTRL M.

Re: How to execute a SAS job through Control M ?

Rixile106 — Thu, 18 Aug 2022 12:50:54 GMT

Is there a video or a document that can guide me through this process , am using SAS enterprise guide

Re: How to execute a SAS job through Control M ?

Kurt_Bremser — Thu, 18 Aug 2022 13:25:18 GMT

Start by making your code batch-ready (no ERRORs, no WARNINGs, clean log). Retrieve dynamic control data from environment variables.

In the company where I worked, we had a shell script called sasbatch which took over all the SAS-related stuff (record the job start, run the job, record the job end and return code).

From Control-M, which still ran on a mainframe, the JCL script created a UNIX wrapper script which set the necesssary parameters for a given job, copied this script to the UNIX server (sftp), ran the script (ssh), and once it was finished, retrieved the results (which were recorded in a file, once again sftp). The SAS job return code (recorded in the file) was then set as exit code for the JCL script.

Re: How to execute a SAS job through Control M ?

LinusH — Mon, 22 Aug 2022 07:16:57 GMT

The documentation tells you how to run in SAS batch mode:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/hostwin/p16esisc4nrd5sn1ps5l6u8f79k6.htm#p01fzykn6n0s73n164xasi1t3ii9

Then it's amatter of triggering it from CTRL M - and here you could get help from you local CTRL M team.

Re: How to execute a SAS job through Control M ?

SASKiwi — Mon, 22 Aug 2022 20:20:41 GMT

Reach out to your SAS administrator. Most likely they are running SAS batch jobs already and can guide you on the steps involved.