BookmarkSubscribeRSS Feed
Ioana_Jo
Fluorite | Level 6

Hi there,

 

I have several DI Studio jobs deployed and scheduled to run in a flow via Schedule Manager. 

All jobs have configured: Status Handling - Condition 'Send Job Status' - Action 'Send Job Status' into a job status table.

If I run a single job in DI, it will send all below information into the table:

user, etl_table, lib, jobname, jobstat, rbefore, rafter, job_rc, sttime, endtime.

If the jobs run via Schedule Manager in a scheduled flow with multiple jobs, it will not write anything into the job status table.

Does anyone have any idea why?

Any help would be greatly appreciated.

 

Thank you!

3 REPLIES 3
Patrick
Opal | Level 21

First thing I'd be doing is look into the Job logs of a job where things work as expected and where things don't work. What's the difference?

 

And just asking: This job status table isn't in WORK - right?

Ioana_Jo
Fluorite | Level 6

%macro etls_sendJobStatus doesn't appear at all in job logs from Job Scheduler run. And it appears when I run the job manually.

The library where the status table is appears as assigned in logs from Job Scheduler run (it isn't a work table).

 

Ioana_Jo
Fluorite | Level 6
It is working now, it seems that the person who had to redeploy the job, didn't do it properly.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 710 views
  • 1 like
  • 2 in conversation