05-18-2017 11:25 PM
Is there any way to view all scheduled jobs on metadata? I woul like to create a daily report using SAS EG that describs all the events that will be triggered in my system.
I am using LSF/Process Manager to schedule my jobs. I was wondering if exist any LSF log or something like this to retrieve this information
05-18-2017 11:38 PM
05-19-2017 05:26 AM
08-08-2017 04:56 PM
Thanks Chris. The code is very useful. Is there anyway to extrat details like if the job is completed succesfully or not? Basically I want generate report which tells how many jobs are executed along with there status.
08-08-2017 04:57 PM
Thanks Timmy. The code is very useful. Is there anyway to extrat details like if the job is completed succesfully or not? Basically I want generate report which tells how many jobs are executed along with there status.
08-09-2017 03:25 AM
what version of SAS are you using? And what SAS Solution? And what is your scheduler? Process Manager (LSF), Windows Task Scheduler, cron/at, or any other job scheduler?
I would not get the information from the metadata because of many reasons: not easy to query this data, but also, and since I see it is one of your objectives, the metadata does not save (and does not know) if a job executed successfully or failed, or its status.
Therefore, the best you can do is to query your job scheduler, and then you can get the return code, status, etc.
08-09-2017 05:14 AM
I work for a dedicated SAS Parner and we recognize your needs and as such our company has created a Job Monitor that will give real time information on jobs that have completed, are currently running and future scheduled jobs based on information in the metadata and information from LSF. It has a web interface that will provide information on when the job started, how long it is/has been running and also provides information on how the current run time compares to completed runs in the past (of course the latter only when statistics have been collected).
The latest version of our Job Monitor is freely available from GitHub and is shared under the GNU 3 license.
Unfortunately we do not have a video available for the latest version, but you can get an impression of an earlier version of the Job Monitor in this video.