#job exceution Waiting for a job to finish before launching another job with xml prompts

acordes — Mon, 21 Jul 2025 13:14:13 GMT

Building on the article

https://documentation.sas.com/doc/en/jobexeccdc/v_004/jobexecug/n1jj26acxr0ictn1riqgxoxrcehu.htm#p16740onala63yn1b33hclbasl0m

I want to pre-filter a table and use this resulting table in the XML prompts

carried out by the second job.

The first job works well, but the second job does not create the form thus fails to do any meaningful.

*  Make the utility macros available;

%jesutil()

*  Declare the program variables;

%global make
		type
        J1JOBID
        J2JOBID
        QUERY_VALUE
        SERVICESBASEURL;

*  Initialize the program variables;

%let DSNAME=class;

%let SERVICESBASEURL=%sysfunc(getoption(servicesbaseurl));

*;
*  Specify that the J1 job is executed in the background.  Progress
*  can be monitored using the SAS Job Execution Web Application 
*  Jobs page (/SASJobExecution/jobs).
*;
%let QUERY_VALUE=FORM('_action'='background' '_program'='/Users/cordear1/My Folder/jobs/test sequential run v1' 'make'="&make" 'type'="&type");
/* %let QUERY_VALUE=FORM('_action'='background' '_program'='/Users/cordear1/My Folder/jobs/test sequential run v1' 'sleep'='5' 'make'="&make" 'type'="&type"); */
/* %let QUERY_VALUE=FORM('_action'='form,prompts,execute' '_program'='/Users/cordear1/My Folder/jobs/test sequential run v2'); */

*;
*  The macro does not wait for the job to finish execution because _action=background is
*  specified.  You use the value of the J1JOBID macro variable with the
*  %JOBEXEC_WAITFOR macro to wait for the job to complete before executing further
*  statements.
*;

%jobexec_run(baseurl=&SERVICESBASEURL,
             in=&QUERY_VALUE,
             jobid_varname=J1JOBID);

%if (&_JOBRUN_RC eq 0) %then %do;
  %put NOTE: You can view the job execution object at /jobExecution/jobs/&J1JOBID;
%end;
%else %do;
  %put ERROR: Problem running the job. &=_JOBRUN_RC  &=_STATUS_MESSAGE;
%end;

*  Wait for the J1 job to finish before executing more statements;

%jobexec_waitfor(baseurl=&SERVICESBASEURL,
                 jobid=&J1JOBID)

%if (&_JOBRUN_RC eq 0) %then %do;
  %put NOTE: Job finished executing. Final job state is "&_JOBRUN_STATE".;
%end;
%else %do;
  %put ERROR: Problem waiting for the job. &=_JOBRUN_RC  &=_STATUS_MESSAGE  &=_JOBRUN_ERRMSG;
%end;

*  Execute the second job;

/* %let QUERY_VALUE=FORM('_program'='/Users/cordear1/My Folder/jobs/test sequential run v2'); */
/* %let QUERY_VALUE=FORM('_action'='json' '_program'='/Users/cordear1/My Folder/jobs/test sequential run v2' 'sleep'='5' 'make'="&make" 'type'="&type"); */

%let QUERY_VALUE=FORM('_action'='form,prompts,execute' '_OUTPUT_TYPE'='html' '_program'='/Users/cordear1/My Folder/jobs/test sequential run v2' 'sleep'='5' 'make'="&make" 'type'="&type");%let QUERY_VALUE=FORM('_action'='json' '_program'='/Users/cordear1/My Folder/jobs/test sequential run v2' 'sleep'='5' 'make'="&make" 'type'="&type");

*;
*  The macro waits for the job to finish execution because _action=background is not
*  specified.  
*;

%jobexec_run(baseurl=&SERVICESBASEURL,
             in=&QUERY_VALUE,
             jobid_varname=J2JOBID);

%if (&_JOBRUN_RC eq 0) %then %do;
  %put NOTE: You can view the job execution object at /jobExecution/jobs/&J2JOBID;
  %put NOTE: You can view the job output at /SASJobExecution/?_jobexec=/jobExecution/jobs/&J2JOBID;
%end;
%else %do;
  %put ERROR: Problem running the job. &=_JOBRUN_RC  &=_STATUS_MESSAGE;
%end;

I suspect that I'm missing the correct definition of the _action or _output_type parameter in the following line.

%let QUERY_VALUE=FORM('_action'='form,prompts,execute' '_OUTPUT_TYPE'='html' '_program'='/Users/cordear1/My Folder/jobs/test sequential run v2' 'sleep'='5' 'make'="&make" 'type'="&type");%let QUERY_VALUE=FORM('_action'='json' '_program'='/Users/cordear1/My Folder/jobs/test sequential run v2' 'sleep'='5' 'make'="&make" 'type'="&type");

Re: #job exceution Waiting for a job to finish before launching another job with xml prompts

DeMer — Tue, 22 Jul 2025 12:28:45 GMT

One thing I think for the error message:

"There is no handler defined for the path /SASJobExecution/jobs..."

the URL should be /jobExecution/jobs instead of /SASJobExecution/

Re: #job exceution Waiting for a job to finish before launching another job with xml prompts

arthurdpereira — Fri, 05 Sep 2025 11:25:54 GMT

Hello @acordes, are you good?

So, the problem is that you're overwriting the QUERY_VALUE macro variable twice on the same line:

%let QUERY_VALUE=FORM(...); %let QUERY_VALUE=FORM(...);

Only the second assignment actually takes effect. So, if you intended to run the job with both settings (HTML and JSON), only the last one (_action='json') is being used.

You should:

Use only one %let QUERY_VALUE=FORM(...) statement at a time, depending on the output you want;
If you want to run both jobs (HTML and JSON), separate them into two blocks, each with its own %let and %jobexec_run.

You're overwriting the macro variable, so only the last value is used. Split them up, and run each job separately with its own macro assignment.

topic Re: #job exceution Waiting for a job to finish before launching another job with xml prompts in SAS Programming

#job exceution Waiting for a job to finish before launching another job with xml prompts

Re: #job exceution Waiting for a job to finish before launching another job with xml prompts

Re: #job exceution Waiting for a job to finish before launching another job with xml prompts