Scheduling using SAS EG, or any other scheduling methods?

[t30]

Hi 

I'm looking at ways to automate some weekly SAS scripts. Currently it needs human intervention on a weekly basis which is kinda redundant and boring.

One of the methods I found require the use of Connection if I were to use SAS EG as below

However when I open my SAS EG, such option is not available as below

Would it be possible to enable this? If not probably it's not part of the license.

What other options do I have? I also looked into 'Task Scheduler' but this requires admin right, so it's not an option.

Thanks

[Kurt_Bremser]

The connection profiles have nothing to do with scheduling, they just define your access to a metadata server.

Since you work locally, you have to use the Windows scheduler.

[t30]

Most of the tables are not locally hosted though, so yeah, I think I still need that connection profile. Is there a reason why my version has no connection profile available?

[SASKiwi]

Connection profiles are only relevant if you are working with a remote SAS server. EG will also work with local SAS on your PC in which case no profile is required.

This SAS note explains how to schedule in EG: http://support.sas.com/kb/56/648.html

You may also want to consider using SAS server-based scheduling which is available in SAS Management Console. This is the most reliable way to do it.

[t30]

Yes, I'm working with both local SAS and remote SAS server, back and forth. Typically because the SAS server has access to the data lake.

Problem is, even if the connection is relevant, I can't find the option there.

[Kurt_Bremser]

If you have a SAS server, do all the scheduling there. Save all your code to .sas files and schedule those, using the Data Step Batch Server.

[SASKiwi]

The scheduling option? You can find it on the EG File menu ==> Schedule Project.