09-02-2016 03:39 AM
I hope this is the right forum for my question and I apologize in advance but I couldn't find a simple solution for my problem.
After a lot of people got fired or left I am now the sole administrator of our Datawarehourse built with SAS. A task that goes a little over my head at times which is why I am asking this question.
We have a flow that runs multiple subflows and jobs every night to get data from source system and feed our Datawarehouse with it. I would like to be able to visualize the running times of this flow and it's subflows/jobs better. Is it possible to connect platform process manager directly and browse its database (if it has one) directly and get the running times?
I have read "Administering Platform Process Manager" and am aware of the possibilty of calling its binary, but that seems kinda unhandy which is why I am asking whether there are other possibilities.
Thank you for your help,
09-02-2016 05:04 AM
What SAS version do you run?
Perhaps it's easier to use more standard logging functionality available through SAS Environment Manager.
09-02-2016 05:55 AM
Yes, it seems that earliest documented release (2.1) is for 9.4.
This, among with lots other things I guess, makes a case for an upgrade to the latest release.
09-02-2016 06:32 AM
While that is on the agenda there is no date set for now. That's why I am looking for a more immediate solution.
09-06-2016 06:21 AM
you can find your information on the history logs of the IBM Process Manager, with you can find on your Process Manager folder, then work\history. You will need probably to parse this file and translate the date/time values.
Another option is to use the jfd comandline program and get the information you need, programatically. For that, please read Administering Platform Process Manager - https://support.sas.com/rnd/scalability/platform/PSS7.1/pm8.20.pdfYou might be interested in the last topics: "About local jobs on Linux and UNIX" and "About local jobs on Windows"
09-06-2016 09:56 AM
given that it is SAS 9.3, using Audit Response Measurement (ARM) might be an option.
For increasing logging, please take a look at
SAS Logging Facility in SAS 9.3:
Initializing the Logging Facility for SAS programs
Here is some info from an old community post, which might provide you with some helpful information as well:
Are there any plans to upgrade to SAS 9.4?
09-07-2016 10:38 AM
09-07-2016 11:15 AM
as for the possible migration to SAS 9.4, are you all set with information on the different ways to upgrade, or would you like some material?