SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How to Check job status after finishing job in DI 3.4?

Reply
Contributor SYN
Contributor
Posts: 39

How to Check job status after finishing job in DI 3.4?

I have three jobs
JOB1
JOB2
JOB3

All three jobs running N number times for different data. If JOB1 abended with errors. I am not interested to run JOB2 and JOB3. I would like to check job status after finishing my job JOB1, JOB2 and JOB3.


can you please help me to provide any command available for STATUS check in DI 3.4?

Thanks in advance.

Super User
Posts: 5,438

Re: How to Check job status after finishing job in DI 3.4?

How are these jobs scheduled?

If you are using Windows Task Scheduler, UNIX cron or LSF/Platform JS, you can build job dependencies in SAS Management Console's Scheduling plug-in.

Data never sleeps
Contributor SYN
Contributor
Posts: 39

Re: How to Check job status after finishing job in DI 3.4?

I am not using any Schedular tools like Windows Task Scheduler, UNIX cron or LSF/Platform.

I am running the jobs using %include command

%include job1

%include job2

%include job3

All jobs put it in DO loop to run N number of times.

How can i check job status? Could you please clarify

Super User
Posts: 5,438

Re: How to Check job status after finishing job in DI 3.4?

If you are in a Windows or UNIX environment, I suggest that you take look at the functionality offered in SMC, it has what you are asking for.

if you still want to stick to using %include, you can test the &job_rc macro variable after each job.

Data never sleeps
Contributor SYN
Contributor
Posts: 39

Re: How to Check job status after finishing job in DI 3.4?

Thank you LinusH.  I would like to use %include.

How can we use &JOB_RC to get the status of job which is getting called by %include?

should we call rcset(%syslibrc) ?

If it so how does it works i am not getting understand.

Could you please clarify?

Super User
Posts: 5,438

Re: How to Check job status after finishing job in DI 3.4?

If &job_rc <> 0 you probably want something to happen, like aborting the SAS session?

The neatest way is to build a macroto do the test and the appropriate action, and call this macro after each %include.

Data never sleeps
Ask a Question
Discussion stats
  • 5 replies
  • 507 views
  • 0 likes
  • 2 in conversation