topic Re: SAS8.3 Enterprise Guide and SQL Database - program automation in SAS Programming

SAS8.3 Enterprise Guide and SQL Database - program automation

rsinha — Mon, 12 Apr 2021 14:52:00 GMT

Hi All, I am trying to automate a process in SAS8.3 Enterprise guide and SQL database. My SAS program pulls the data from SQL Database, performs some Proc SQL & Data Steps and pushes the cleaned data back to SQL table. I want to automate this process and schedule it to run on a weekly basis. I tried basic scheduling of Enterprise Guide process flows and projects:-

“File” -> “Schedule Project” or click on “Schedule” the workspace and then select “Project” or “Process Flow”. This opened up my operating system scheduler and I am able to see my scheduled task but it never gets executed. Being a beginner in SAS , I am clueless about how to proceed further and possibly debug the situation.

Re: SAS8.3 Enterprise Guide and SQL Database - program automation

ChrisNZ — Thu, 15 Apr 2021 06:05:36 GMT

If the task is scheduled in the scheduler then it is a scheduler issue. What does the scheduler display?

Re: SAS8.3 Enterprise Guide and SQL Database - program automation

ChrisNZ — Thu, 15 Apr 2021 11:22:52 GMT

Ans what happens if you run y hand the command entered in the scheduler's task?

Re: SAS8.3 Enterprise Guide and SQL Database - program automation

rsinha — Fri, 16 Apr 2021 12:06:06 GMT

The scheduler just shows up the task as ready. please see the pic for reference

Re: SAS8.3 Enterprise Guide and SQL Database - program automation

rsinha — Mon, 19 Apr 2021 13:14:19 GMT

Thanks for your reply. It was indeed the scheduler's problem... some default settings prevented it from running the task when the device was on Battery.