If you have a Stored Process that occasionally "hangs" while executing
and does not produce a SAS log, the "%stp_capture_log" macro should
be helpful.  This macro reroutes and saves the SAS log for each request
to a separate log file.  It also creates a "status" file (with the same
ID number as the log file) that indicates whether or not the request ran
successfully.

This macro is useful for requests that run using the Stored Process
Server, Workspace Server, IntrNet Application Server or SAS/CONNECT
server.

You can download the macro at:

  http://ftp.sas.com/techsup/download/inttech/STP_Capture_Log.zip

The "Readme.txt" file contains instructions for using the macro.

Example Usage

  %stp_capture_log(request=begin,
                   log_directory=c:\temp);

     /*  Beginnning of your existing code */

     %stpbegin;

       proc print data=sashelp.class;
       run;

     %stpend;

     /* End of your existing code */

  %stp_capture_log(request=end);

Operating System and Release Information