topic Re: Viya job does not execute new code in Administration and Deployment

Viya job does not execute new code

jblack38 — Thu, 19 May 2022 14:23:54 GMT

I have a SAS program, Save_Audit_History, I created several months ago in Viya SAS Studio (using the Develop SAS Code option in the Viya application menu).

I scheduled the code to execute on a schedule in the Jobs application in Environment Manager (Manage Environment in the Viya menu). I scheduled it by selecting the New option on the Scheduling tab and then selecting the job by browsing to it in the New Job window.

The job recently started getting errors due to CAS data limit. I added the code

options casdatalimit=500M;

to increase the limit.

When the scheduled job runs, it still fails. When I look at the log for the job, it does not contain my new code.

Do I need to create a new job every time I change the code for a program?

Thanks!

Jerry

Re: Viya job does not execute new code

acordes — Thu, 19 May 2022 15:04:18 GMT

Try wrapping the proc sql command in its casl sibling proc fedsq.

proc cas;
source MPG_toyota;
'your sql command'
endsource;
fedSQL.execDirect / query=MPG_toyota;
quit;

start from my example

proc cas;
source MPG_toyota;
		create table public.sum22{options replace=true} as 
			select a.sales_res as feb_sales_res, b.sales_res, case when round(a.sales_res-b.sales_res,3)=0 then 1 else 0 end as flag 
               from RISKNOBA.REMA_FEB22_FMT_OUT a inner join RISKNOBA.REMA_DEC21_FMT_OUT b 
			on a.bastidor=b.bastidor  ;
endsource;
fedSQL.execDirect / query=MPG_toyota;
quit;

Re: Viya job does not execute new code

jblack38 — Thu, 19 May 2022 15:13:34 GMT

The problem is that the Viya JOB does not see any changes I make to the code. I even added a new comment line and it did not show up in the job log.
So making these changes to the code will not be seen by the job.

Re: Viya job does not execute new code

gwootton — Thu, 19 May 2022 16:03:03 GMT

Yes, when you schedule a job the code gets written into the job object rather than being linked to the program you are saving, so you would need to create a new job. You might consider creating a program that does an %include against your program in the files service using the filename statement's filesrvc access method, then when you edit the code it will run the current version.

FILENAME Statement: FILESRVC Access Method
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lestmtsglobal/p0qapul7pyz9hmn0zfoefj0c278a.htm

Re: Viya job does not execute new code

jblack38 — Thu, 19 May 2022 16:37:19 GMT

Thanks Greg!
That is what I suspected.
Good suggestion on using an %include.

Re: Viya job does not execute new code

nikogallo — Mon, 06 Feb 2023 08:22:23 GMT

the best practice to optimize the work.

😞

Re: Viya job does not execute new code

nikogallo — Mon, 06 Feb 2023 08:23:53 GMT

but if the job is included in Jobs-flows must the job included in it also be updated?

Re: Viya job does not execute new code

gwootton — Mon, 06 Feb 2023 14:56:58 GMT

When you save the job the code is stored separately from when you created the code, so any changes would require creating the job again.