Desktop productivity for business analysts and programmers

Scheduled Jobs

Accepted Solution Solved
Reply
Contributor
Posts: 73
Accepted Solution

Scheduled Jobs

Hello EG Users,

I am using Ordered List for purpose of seggregating various portions of nodes in my SAS EG project, so that I can be sure that temporary datasets get populated in proper order and not run into error while generating final reports.

Eventually, I intend to created scheduled job to run this SAS EG project. There are two ways to handle this:

1) Convert code to stored process and create scheduled job via SAS EG

2) Export code to DI Studio and run it on schedule on SAS server

My confusion is with understanding if Ordered List can be directly used to convert code into stored process and then scheduled job?

Or I have to make sure that the x & y co-ordinates of nodes in question is up-to-the-mark so that the code generated in appropriate?

Thanks,

Dhanashree


Accepted Solutions
Solution
‎05-02-2014 10:09 AM
Trusted Advisor
Posts: 3,208

Re: Scheduled Jobs

http://support.sas.com/resources/papers/proceedings09/157-2009.pdf

http://blogs.sas.com/content/sasdummy/2011/10/10/10-tips-for-organizing-your-sas-enterprise-guide-pr...

http://support.sas.com/resources/papers/proceedings12/301-2012.pdf

All the connected lines in the process flow they are representing dependicies in the same way as s scheduler you can use them with "run branch"

This is very usefull when you define the order/dependicy and control that.

Having no LSF than there is no option in SMC to use that (process manager).

Ahh somewhere people are running SAS code in a scheduled way in a possible operational environment. I know that approach.

Suppose there is a team that is just running "jobs' they use a scheduler. As customer you can go for a service request, so you can deliver them a script and the code they will run. Commonly there is a very burocratic procedure to achieve something. Just ask for that, you will see what they can do for you .

---->-- ja karman --<-----

View solution in original post


All Replies
Trusted Advisor
Posts: 3,208

Re: Scheduled Jobs

Confusing question as I see: 26177 - Avoid Entropy with the Ordered List Using SAS Enterprise Guide

The task flow is the one for all dependicies (connecting the nodes)

A stored process is a piece of code stored on the server that is registered in sas metadata.

I you want to schedule code is a piece of code that can be used by scheduler eg LSF (SMC schedule manager).  

There is some difference in this sentences, the technical approach is really different.

Di studio is a code generator using metadata table/field definitions. Why would export code to a code generator?

The scheduler DI is using is the same you can use with scheduled batch processing eg LSF (SMC schedule manager) 

---->-- ja karman --<-----
Contributor
Posts: 73

Re: Scheduled Jobs

Does Task Flow handle any / all nodes used in process flow like query? It just shows Transpose template as an option.

My basic goal is to use already created ten Ordered Lists to generate code that can be scheduled on our SAS server to run daily and totally avoid worrying about where and how the nodes are placed on process flow canvas. That will eliminate the painstaking effort of re-arranging the nodes so that they run in correct order.

I don't believe we have license to Load Sharing Facility so that is out of question.

I mentioned DI Studio because we already run scheduled jobs that were created by ex-SAS engineers from SAS EG projects. I haven't spent time reverse engineering that process yet, hence the dilemma.

Thanks!

Solution
‎05-02-2014 10:09 AM
Trusted Advisor
Posts: 3,208

Re: Scheduled Jobs

http://support.sas.com/resources/papers/proceedings09/157-2009.pdf

http://blogs.sas.com/content/sasdummy/2011/10/10/10-tips-for-organizing-your-sas-enterprise-guide-pr...

http://support.sas.com/resources/papers/proceedings12/301-2012.pdf

All the connected lines in the process flow they are representing dependicies in the same way as s scheduler you can use them with "run branch"

This is very usefull when you define the order/dependicy and control that.

Having no LSF than there is no option in SMC to use that (process manager).

Ahh somewhere people are running SAS code in a scheduled way in a possible operational environment. I know that approach.

Suppose there is a team that is just running "jobs' they use a scheduler. As customer you can go for a service request, so you can deliver them a script and the code they will run. Commonly there is a very burocratic procedure to achieve something. Just ask for that, you will see what they can do for you .

---->-- ja karman --<-----
Contributor
Posts: 73

Re: Scheduled Jobs

Thank you so much!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1476 views
  • 0 likes
  • 2 in conversation