List of scheduled jobs

[Guiluiz]

Hello Folks!

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

Thanks!

[Timmy2383]

I wrote some rudimentary code that does this, assuming your computer server(s) have access to the file system/directory where Platform Process Manager is installed and is also on Unix/Linux platform. Let me know if you're interested and I can get it to you tomorrow if someone esle hasn't already done so.

[CHandberg]

Hi...

I've attached some code i made some time ago... I think you can use it. If not directly, then for inspiration...

It's made to run in Base SAS on the server running the metadata-server...

Good luck 🙂

[mpratapwar]

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.

[Damo]

Hi @Guiluiz

(Might not be helpful but...)

Bjobs might be useful to list all scheduled jobs.

You can use the output to build your report.

Cheers,

Damo

[Timmy2383]

Here's my code. I think the only requirement is that you have read access to the Platform Process Manager installation folder from your SAS session

[mpratapwar]

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.

[JuanS_OCS]

Hello @Guiluiz,

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.

[Resa]

Hi @Guiluiz

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.

--Resa