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
SAS Super FREQ
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
SAS Super FREQ
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

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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