BookmarkSubscribeRSS Feed
rsinha
Fluorite | Level 6

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. 

4 REPLIES 4
ChrisNZ
Tourmaline | Level 20

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

ChrisNZ
Tourmaline | Level 20

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

rsinha
Fluorite | Level 6

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

rsinha_0-1618574759032.png

 

rsinha
Fluorite | Level 6
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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1303 views
  • 3 likes
  • 2 in conversation