BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
elisehoo1
Obsidian | Level 7

Goodday @AllanBowe ,

 

 Wondering if anything i missed out here . appreciate if you can advise , Thanks

 

1. i had added few lines inside compute contexts from job execution compute context (first diagram)

2. trigger one of the scheduled job  (second diagram)

3. i checked the log but the %let statement that i put there was not executed. 

 

elisehoo1_0-1620895223858.png

 

elisehoo1_1-1620895362398.png

 

 

AllanBowe
Barite | Level 11

Hi  @elisehoo1 - two things:

1) the options must be in "system option" format, not written as an options statement, eg with the initial dash.  See example here.

2) you don't typically see the log from the autoexec in the resulting session.  

 

On that last point - in testing I've also found (with a pooled session, in 3.5) that the autoexec is not "viya aware" - so you cannot set CASLIBs for instance, and not all macro variables are available.

/Allan
SAS Challenges - SASensei
MacroCore library for app developers
SAS networking events (BeLux, Germany, UK&I)

Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller
DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs