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

Abort JOB - DI Studio 4.6

Accepted Solution Solved
Reply
Contributor
Posts: 58
Accepted Solution

Abort JOB - DI Studio 4.6

I need abort a job if the source table of this job is empty or does not exist.

Does anyone know how I can do this in DI Studio 4.6 within a job?


Accepted Solutions
Solution
‎01-16-2014 03:35 PM
Super User
Posts: 5,427

Re: Abort JOB - DI Studio 4.6

Posted in reply to DaveR_SAS

Just want to add, status handling is performed on the result of a transformation, not on a source table as such. Probably you can use it anyway when designing your exceptions, just bare this in mind.

An exception is if your table you want to check is a look-up table in the Look-up transform, this transformation can explicitly check the status of the source table.

Data never sleeps

View solution in original post


All Replies
SAS Employee
Posts: 75

Re: Abort JOB - DI Studio 4.6

Posted in reply to DavidCaliman

The topic in the 4.6 user guide describes a general approach: SAS(R) Data Integration Studio 4.6: User's Guide

I think you would specify the "Table Does not Exist" condition: SAS(R) Data Integration Studio 4.6: User's Guide

Solution
‎01-16-2014 03:35 PM
Super User
Posts: 5,427

Re: Abort JOB - DI Studio 4.6

Posted in reply to DaveR_SAS

Just want to add, status handling is performed on the result of a transformation, not on a source table as such. Probably you can use it anyway when designing your exceptions, just bare this in mind.

An exception is if your table you want to check is a look-up table in the Look-up transform, this transformation can explicitly check the status of the source table.

Data never sleeps
Contributor
Posts: 58

Re: Abort JOB - DI Studio 4.6

I solved the problem by using the lookup Exception.

Thank you very much.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 711 views
  • 3 likes
  • 3 in conversation