BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Can I have a job within a job. if yes then how? How is the nesting of procedures done within Data Integration?
3 REPLIES 3
Cynthia_sas
Diamond | Level 26
Hi:
This is not a stored process question.

Generally speaking, if you have a library of SAS Autocall macro programs (let's say you had some macro programs for daily versus weekly processing...then you might have a SAS program with code like this:
[pre]

%macro myjob;

%if (condition for daily processing) %then %do;
%daily;
%end;
%else %if (condition for weekly processing) %then %do;
%weekly;
%end;

%mend myjob;

%myjob;
[/pre]

The macro program does not define the %DAILY or the %WEEKLY macro programs, it just calls them from the autocall macro location on your BI server.

Or, if you have the job scheduler set up and implemented in your configuration, there are ways to submit multiple jobs and define job dependencies.

Again, the best resource for your questions is the Platform Administration or Job Scheduler documentation and/or the Data Integration Studio class or the Data Integration Fast Track class or consulting Tech Support.

cynthia
LinusH
Tourmaline | Level 20
In the current release there is limited support for nesting jobs. By using Loop and Loop end transformations you can conditionally call/loop one other DI Studio job. I believe there will some more functionality in this area with 9.2 version.

But you can whatever you like by using the Cynthia mention, but then It won't be a DI Studio process.

Regards,
Linus
Data never sleeps
Cynthia_sas
Diamond | Level 26
But they can still put the code block with the macro call in the flow. And/or they can put it in a SP and turn the SP into a DI studio job. But generally when it comes down to questions like this, I always have to go back to the beginning and ask -- what is the situation that leads needing a job within a job? Examine those conditions and requirements and see whether there is another approach that would work equally well.

cynthia

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 2201 views
  • 0 likes
  • 3 in conversation