- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
The documentation tells you how to run in SAS batch mode:
Then it's amatter of triggering it from CTRL M - and here you could get help from you local CTRL M team.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Reach out to your SAS administrator. Most likely they are running SAS batch jobs already and can guide you on the steps involved.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.