Capture session start / finish times and request details. More...

Go to the source code of this file.

Detailed Description

For details, see http://www.rawsas.com/2015/09/logging-of-stored-process-server.html. Requires a base table in the following structure (name can be changed):

proc sql; create table &libds( request_dttm num not null format=datetime. ,status_cd char(4) not null ,_metaperson varchar(100) not null ,_program varchar(500) ,sysuserid varchar(50) ,sysjobid varchar(12) ,_sessionid varchar(50) );

Called via STP init / term events (configurable in SMC) as follows:

mp_stprequests(status_cd=INIT, libds=YOURLIB.DATASET )

Parameters

status_cd=	Use INIT for INIT and TERM for TERM events
libds=	Location of base table (library.dataset). To minimise risk of table locks, we HIGHLY recommend using a database (NOT a SAS dataset). THE LIBRARY SHOULD BE ASSIGNED ALREADY - eg in autoexec or earlier in the init program proper.

Version

9.2

Author

Allan Bowe https://github.com/Boemska/macrocore

Definition in file mp_stprequests.sas.