BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi

I'm wondering if anyone can help me with a litlle problem.

My intention is to run a Job that populates a table and then extract into a table, the Datetime when the Job started running, the Job Name, wich table is being populated, the Status (Ended Successufully or with errors) and the Datetime that the Job ended.

Is it possible to extract all this from the log into a table?
If so, can you help me please.

Thanks
3 REPLIES 3
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
The SAS support website http://support.sas.com/ has at least one SAS code sample related to your post. I found the item using the SEARCH facility on the website.

Scott Barry
SBBWorks, Inc.

Sample 34301: Parse SAS Logs to Extract Performance and Timing Information
http://support.sas.com/kb/34/301.html
Cynthia_sas
SAS Super FREQ
Hi:
In addition to Scott's suggestion, you might also want to check with your SAS Administrators. If you are using the SAS Enterprise Intelligence Platform and you want to get log information from the Workspace server logs or the Stored Process server logs, you may find that the macro program as provided on the Tech Support site needs some modification to run in the Platform environment. You may or may not have read access (programmatically) to the LOG file created on the Platform when your stored process runs.

If you are talking about the log from SAS Stored Process execution, there are some reserved macro variables, such as &_PROGRAM, which contains the name of the stored process and others like &_REPOSITORY, &_SRVNAME, &_SRVPORT which might prove useful.

Info on stored process reserved macro variables can be found here:
http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/reserved.html

cynthia
deleted_user
Not applicable
A big thank you to Cynthia and Scott but I've found everything I need in:
Job Properties ->Status Handling tab -> Job Status

Thank you

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 843 views
  • 0 likes
  • 3 in conversation