topic Re: How to get All active SAS users and All SAS scheduled Jobs in Administration and Deployment

How to get All active SAS users and All SAS scheduled Jobs

SAM_2025 — Wed, 05 Mar 2025 06:55:06 GMT

Hi All,

I want to pull all the SAS users who are active only. Also, I want to get list of all SAS scheduled Jobs including the timestamp start and end time like how long it takes for this job.

Re: How to get All active SAS users and All SAS scheduled Jobs

LinusH — Wed, 05 Mar 2025 11:09:53 GMT

Please provide som additional information (including, not limited to):

- SAS version/products in use

- OS

- Scheduler used

- Definition of "active user"

Re: How to get All active SAS users and All SAS scheduled Jobs

SAM_2025 — Fri, 07 Mar 2025 08:47:17 GMT

@LinusH

we are using SAS Management Console (9.4) and SAS Enterprise Guide (7.1) which installed on our machine (windows).

For backend checking logs and other privileges we are accessing the server from unix .

Active users means who still using the system.

Re: How to get All active SAS users and All SAS scheduled Jobs

Kurt_Bremser — Fri, 07 Mar 2025 10:25:54 GMT

Users currently logged on or having used SAS in any way within a given time frame?

Re: How to get All active SAS users and All SAS scheduled Jobs

Nigel_Pain — Fri, 07 Mar 2025 11:42:17 GMT

For SMC check the metadata server logs. Look for entries with "APPNAME=SASManagementConsole "

For EG users I don't think the metadata logs will tell you if an actual SAS session has been started, only if they've connected to the metadata. You could get active users from the Object Spawner logs (that's what I do).

Re: How to get All active SAS users and All SAS scheduled Jobs

LinusH — Fri, 07 Mar 2025 13:22:14 GMT

It's common for data warehouse application to include specific job logging, r.g., using macros. But this is not the case for your I guess?

An option to see what is actually being executed is to use the Job Monitor plugin to Environment Manager. It requires a little bit of configuration.

I don't think there's a OOTB listing available within SMC. This could be available in third party tool, like Data Controller for SAS.

What scheduler do you use?

Re: How to get All active SAS users and All SAS scheduled Jobs

SAM_2025 — Tue, 11 Mar 2025 06:28:19 GMT

Yes, anyone using SAS or even only viewing reports.

Re: How to get All active SAS users and All SAS scheduled Jobs

SAM_2025 — Tue, 11 Mar 2025 06:29:58 GMT

Can you specify where exactly from SMC I can check these logs?

Re: How to get All active SAS users and All SAS scheduled Jobs

SAM_2025 — Tue, 11 Mar 2025 06:32:26 GMT

I'm not sure about the meaning of "What scheduler do you use?" but usually we use SMC to schedule our jobs.

Re: How to get All active SAS users and All SAS scheduled Jobs

Nigel_Pain — Tue, 11 Mar 2025 10:31:59 GMT

You can't view the logs from SMC. You have to log onto the server(s) to do so. For the metadata server logs, these will commonly be in <config>/Levx/SASMeta/MetadataServer/Logs on the metadata server and for the object spawner logs, <config>/Levx/ObjectSpawner/Logs on the compute server.

When @LinusH asks about the scheduler, SMC is only the front end to this. Behind the scenes it will be relying on specific scheduling software. It could be Platform Suite for SAS if you have that licensed or the operating system scheduler on your servers (ie. cron on Unix or Linux, or the Task Scheduler on Windows). Here's where you set that in SMC:

Re: How to get All active SAS users and All SAS scheduled Jobs

LinusH — Tue, 11 Mar 2025 14:02:38 GMT

If you execute jobs interactively from SMC, then you don't use an external scheduler.
But if you deploy job flows to be triggered by time or files, then you are most likely using an external scheduler, like crontab. This should be defined as a server in SMC.

Re: How to get All active SAS users and All SAS scheduled Jobs

SASKiwi — Tue, 11 Mar 2025 19:13:25 GMT

@SAM_2025 - When you schedule a job in SMC you have to select a scheduling server. If you have licensed Platform Process Manager with SAS then that is one of the options you can select:

In that case you are actually using a different scheduler to the other two default SAS options. Scheduled job details are stored in SAS metadata, but that wont tell whether they are actually being used or not. If you use PPM then that has a separate database you could query to get history of scheduled jobs.

Re: How to get All active SAS users and All SAS scheduled Jobs

SAM_2025 — Wed, 12 Mar 2025 07:28:43 GMT

Thaks for the explanation!
we use Operating System Services from the scheduling Server dropdown.

Re: How to get All active SAS users and All SAS scheduled Jobs

SAM_2025 — Wed, 12 Mar 2025 07:31:01 GMT

Yes, I can see the logs under path <config>/Levx/SASMeta/MetadataServer/Logs

But how can I pull the names of the Scheduled jobs? the Logs are huge in size. Is there a SAS code that I can run in EG to get an output?

Re: How to get All active SAS users and All SAS scheduled Jobs

Nigel_Pain — Wed, 12 Mar 2025 10:16:21 GMT

I don't think you'll get the scheduled jobs from the metadata logs, only entries where people are logging in to the metadata server (and filtering on "APPNAME=SASManagementConsole" will give you the users who have done this with SMC). I see from a later reply that you're using Operating System Services as your scheduler so for scheduled tasks you'd maybe need to look at logs within <config>/Lev1/SchedulingServer. In Windows there's a directory structure here of <username>\<jobname> with logs created by the job's VB Script. I don't know if that helps? Or, the actual SAS programs run under the Batch Server, so there are SAS logs in <config>/Lev1/SASApp/BatchServer/Logs. Alternatively, I'm not knowledgeable enough about Unix to know if there are logs created by cron? Might be entries in syslog?

Re: How to get All active SAS users and All SAS scheduled Jobs

Kurt_Bremser — Wed, 12 Mar 2025 13:02:20 GMT

When you run SAS programs from cron, you should always use the -log option to explicitly set the log location. Otherwise you might get permission/write failure issues for the log file.

Re: How to get All active SAS users and All SAS scheduled Jobs

LinusH — Wed, 12 Mar 2025 14:40:10 GMT

There is no OOTB options for generating lists.
Job Monitoring might here as well, I haven't tried it.
The deployed/scheduled (active) job flows are visible within SMC and crontab.
The executed job flows are logged in your configuration directory. These logs are usually easy to grasp, but they still are not lists.
This information could probably be extracted from metadata, but that's outside what I have don in the past.