topic Re: Starting EG automatically (via Win Scheduler) and supplying a project name in SAS Enterprise Guide

Starting EG automatically (via Win Scheduler) and supplying a project name

PoulRavn — Mon, 22 May 2017 07:55:44 GMT

Hi, I've been trying to understand how to automatically start EG61 with a project as input parameter. I can get EG61 started OK, but how to supply the project file? I did not yet find any post/google hits on it. Help appreciated.

Regards

Poul R S

Re: Starting EG automatically (via Win Scheduler) and supplying a project name

BrunoSilva — Mon, 22 May 2017 08:18:44 GMT

Hello,

If you open the VBScript you will notice that there's a "prjName" variable with the path and the name of your project.

So probably you can use VBS arguments to the variable (just supposing never tried before)

Something like this:

prjName = Wscript.Arguments(0)  'Project Name

And then when you call you VBS you pass the parameter.

Have a try 🙂

Best regards,

Bruno Silva

Re: Starting EG automatically (via Win Scheduler) and supplying a project name

PoulRavn — Mon, 22 May 2017 08:23:45 GMT

I am sorry, but you missed me there.

I set EG up to start in the Scheduler in Win 7. I did not launch it via a VBS script, - that I know of. But perhaps the Scheduler creates a VBS anyway? Is that what you mean?

Regards

Poul

Re: Starting EG automatically (via Win Scheduler) and supplying a project name

BrunoSilva — Mon, 22 May 2017 08:30:33 GMT

Hello,

When you schedule through the Enterprise Guide he creates a VBS file somewhere. I was referring to change that VBS file but if you schedule directly like this:

.../../SASGuide.exe <projectfile.egp>

If so maybe you can create a .sh or .bat file that accepts parameters and then make the call.

Best Regards,

Bruno Silva

Re: Starting EG automatically (via Win Scheduler) and supplying a project name

Kurt_Bremser — Mon, 22 May 2017 08:58:50 GMT

If that scheduling is more than just a pet project of yours, I strongly recommend creating a .sas code file from your project and schedule that on the SAS server directly, using your organization's standard scheduler. Desktops are not suited to do business-critical jobs.

Re: Starting EG automatically (via Win Scheduler) and supplying a project name

PoulRavn — Mon, 22 May 2017 09:08:41 GMT

It's kind of in between 'business critical' and pet. I want to update 2 dashboards, that show running data from production. I am updating them manually now, but want it to be automatic.
Kind regards Poul

Re: Starting EG automatically (via Win Scheduler) and supplying a project name

Kurt_Bremser — Mon, 22 May 2017 10:35:42 GMT

If your SAS is located on a server, I'd still go for doing the scheduling there; every solution you solve along the way will be handy on the day when you have a real scheduling need.

So I recommend saving your code to a single .sas file and run that in batch mode on the server.

Only if you have a single-machine install of SAS on your desktop will scheduling a project via EG make any sense, IMO.