topic SAS EG and Windows Scheduler in SAS Enterprise Guide

SAS EG and Windows Scheduler

BCNAV — Tue, 21 Nov 2017 14:37:26 GMT

Hi all,

Not sure this is the best sub-forum, so mods please move if you feel necessary.

We have some SAS projects that are run via Windows Scheduler. They run for a bit, but then run for a few seconds and do nothing. These jobs typically take about 30 mins. to run. But it seems that after about a week of successful runs, they initiate, say they run, and finish, all in about 9 seconds.

Has anybody heard of this happening and any resolutions? This is very weird.

Perhaps a Windows Scheduler alternative?

thanks

Re: SAS EG and Windows Scheduler

Kurt_Bremser — Tue, 21 Nov 2017 14:54:38 GMT

What do the logs say?

Note that one of the inherent advantages of running SAS codes (.sas files) in batch is the fact that you can easily keep the log of every run, as nothing needs to be overwritten.

Re: SAS EG and Windows Scheduler

Bill — Tue, 21 Nov 2017 15:27:02 GMT

Indeed, check the log files.

For an alternate to Windows Scheduler, take a look at SplinterWare. Outperforms WS by miles, only $30 for a license, 30 day free testing

Re: SAS EG and Windows Scheduler

BCNAV — Tue, 21 Nov 2017 15:44:33 GMT

Here is the rub guys.....

The, there is NO SAS log. Windows scheduler will says it starts the task, then 9 seconds later it says task completed. SAS never executes. This does not happen for all SAS projects. And some, no matter what machine we run them on, will start off running ok, then the same "9 second funniness" returns. This really is not a SAS issue, I don't think, but any insight is great.

Re: SAS EG and Windows Scheduler

Kurt_Bremser — Tue, 21 Nov 2017 19:25:08 GMT

Convert your projects to .sas files and run them in batch.

This gives you much more options than scheduling projects (other schedulers, other operating system).

Re: SAS EG and Windows Scheduler

BCNAV — Wed, 22 Nov 2017 15:23:41 GMT

I have exported the EG project to a .sas file. Oddly enough it will not run:

2         Libname UDRDWPRD ORACLE 'UDRDWPRD.world' ;

ERROR: Incorrect syntax for this LIBNAME statement. This engine does not accept a physical name.
ERROR: Error in the LIBNAME statement.

This was not touched by me. Just the standard File Export All Code In Project

Re: SAS EG and Windows Scheduler

SASKiwi — Wed, 22 Nov 2017 21:07:05 GMT

The correct syntax looks like this:

Libname UDRDWPRD ORACLE path = 'UDRDWPRD.world' user = MyUserName password = MyPassword;