Scheduling Data Integration Studio jobs from SAS Management Console

lfabbri — Wed, 06 Mar 2019 14:10:15 GMT

Hello everyone,

I am trying to understand how can I schedule a job defined in SAS Data Integration Studio using the Management console.

From this guide about SAS Scheduling it seems there are multiple ways to schedule a job:

Flow Scheduler
Platform Suite for SAS
Operating system scheduler
Distributed in-process scheduling
In-process scheduling

If I understand correctly some of these components require license, while others are not suited for deploying Data Integration jobs (e.g. In-process scheduling work only for reports, correct me if I'm wrong). For example in the documentation for the Flow Scheduler I read:

To enable scheduling with SAS Job Flow Scheduler, you must set up a scheduling server. You must include SAS Job Flow Scheduler and the Web Infrastructure Platform Data Server in your plan file. You must select Web Infrastructure Platform Scheduling Services, SAS Job Flow Scheduler Server, SAS Job Flow Scheduler Orchestrator, and SAS Job Flow Scheduler Trigger in the SAS Deployment Wizard. If you are using SAS Job Flow Scheduler in a grid, you must also include SAS Grid Manager Control Server in your plan file and select SAS Workload Orchestrator in the SAS Deployment Wizard.

If I run "proc init" from SAS console I can see the following products licensed:

---Base SAS Software
30MAY2019
---SAS/CONNECT
30MAY2019
---SAS Integration Technologies
30MAY2019
---SAS/Secure 168-bit
30MAY2019
---SAS/Secure Windows
30MAY2019
---SAS/ACCESS Interface to Microsoft SQL Server
30MAY2019
---SAS Metadata Bridges for General Industry Standards
30MAY2019
---SAS Workspace Server for Local Access
30MAY2019
---SAS/ACCESS to Postgres
30MAY2019

I've tried to deploy a job from Data Integration Studio and then to create a new Flow in the Scheduler from the Management Console, but when I've tried to edit the schedule options I got errors. I've also tried creating different scheduling server for the Flow (Operating System Services, Platform Process Manager, SAS In-Process Services), but no one worked.

In particular I've tried to set up an Operating System Services scheduler following the steps in the documentation:

To enable operating system scheduling, you must have a scheduling server. If you use the SAS Deployment Wizard to install and configure an operating system scheduling environment, all required items are automatically configured. You must include Operating System Services Scheduling Server 9.4 and SAS DATA Step Batch Server 9.4 in your plan file and select these two items in the SAS Deployment Wizard.
The setup tasks are as follows:
1.Assign local administration rights to users (Windows only).
2.Assign directory and file permissions.
3.Define an operating system scheduling server.
4.Assign a spawner to the operating system scheduling server.

On Windows systems, the user ID under which the job will be run must have Local Administration rights on the scheduling server. To grant these rights, add the user to the Administrators Group.
This task is performed automatically by the SAS Deployment Wizard.
26 Chapter 4 • Setting Up Scheduling Using Operating System Scheduling
Step 2: Assign Directory and File Permissions
You must assign operating system Read and Write permissions to the following directories:
Windows:
•sas-config-dir/Lev1/SchedulingServer
•sas-config-dir/Lev1/SchedulingServer/logs
•sas-config-dir/Lev1/SchedulingServer/sasuser

Note:You can use either forward or backward slashes on Windows systems.
You must also assign Execute permission to sas-config-dir/Lev1/SchedulingServer/SchedulingServer.bat (Windows) or sas-config-dir/Lev1/SchedulingServer/SchedulingServer.sh

Define an operating system scheduling server in the metadata repository. This task is performed automatically by the SAS Deployment Wizard. When created, the server definition has the following properties:
SubType
Specifies the operating system being used for scheduling
Control Directory Contains the path for the directory that will store the script for executing a flow. For a default installation, the directory is sas-config-dir/Lev1/SchedulingServer.
Command
The appropriate SAS command for starting the scheduling server.. Sample commands are as follows:
Step 3: Define an Operating System Scheduling Server 27

Windows:
•"sas-config-dir\Lev1\SchedulingServer\Schedulingserver.bat"
Object Server Parameters applevel=2
Authentication Domain DefaultAuth
Host Name The name of the machine that hosts the scheduling server.
Port 8451

I have to setup all manually, since these steps where not included during the installation of SAS. I have doubts about the "sas-config-dir\Lev1\SchedulingServer\Schedulingserver.bat" file, there is no such a file in my sas-config-dir\Lev1\SchedulingServer\ folder. I guess I need to create one, but I don't know what commands should be put in this .bat file.

Please anyone can provide some help on how to correctly setup the operating system scheduler manually?

Re: Scheduling Data Integration Studio jobs from SAS Management Console

Mark_sas — Fri, 08 Mar 2019 14:17:18 GMT

You may be able to get away with rerunning the SAS Deployment Wizard, and choosing to selectively configure products. Then choose Operating System Services Scheduling Server in the product dialog and configure. If you're still having trouble activating this scheduling server, please contact Technical Support.

Re: Scheduling Data Integration Studio jobs from SAS Management Console

lfabbri — Fri, 08 Mar 2019 14:22:02 GMT

Hi @Mark_sas , thanks for the answer.

I've tried already to start the deployment wizard, but in the products options for sas or related sas software there is no entry for "Operating System Services Scheduling" or anything similar. Do you know where is located to perform the installation from the wizard?

topic Scheduling Data Integration Studio jobs from SAS Management Console in Administration and Deployment

Scheduling Data Integration Studio jobs from SAS Management Console

Re: Scheduling Data Integration Studio jobs from SAS Management Console

Re: Scheduling Data Integration Studio jobs from SAS Management Console