Architecting, installing and maintaining your SAS environment

List of scheduled jobs

Reply
Senior User
Posts: 1

List of scheduled jobs

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!

Regular Contributor
Posts: 170

Re: List of scheduled jobs

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.
Occasional Contributor
Posts: 6

Re: List of scheduled jobs

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 :-)

 

Attachment
New Contributor
Posts: 2

Re: List of scheduled jobs

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.

SAS Employee
Posts: 69

Re: List of scheduled jobs

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

Regular Contributor
Posts: 170

Re: List of scheduled jobs

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

Attachment
New Contributor
Posts: 2

Re: List of scheduled jobs

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.

Trusted Advisor
Posts: 1,141

Re: List of scheduled jobs

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.

 

 

 

 

Frequent Contributor
Posts: 84

Re: List of scheduled jobs

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

Ask a Question
Discussion stats
  • 8 replies
  • 367 views
  • 3 likes
  • 7 in conversation