How to abort the job

sagar deshmukh · Post by **sagar deshmukh** » Fri Jan 02, 2009 4:43 am

Hi i have developed a sever job which is pretty simple,It just has Oracle Stage which will Extract data into the Sequential file.

But many times query is not pulling the records from table so the black file is getting generated

Can you please tell me how to abort the job if the no data gets fetched?

ray.wurlod · Post by **ray.wurlod** » Fri Jan 02, 2009 4:46 am

Why bother? You can check the row count in an after job subroutine and set the ErrorCode argument to a non-zero value to abort the job. You may like to have the after job subroutine delete the empty file first.

sagar deshmukh · Post by **sagar deshmukh** » Fri Jan 02, 2009 5:37 am

can you please elaborate little more

ray.wurlod · Post by **ray.wurlod** » Fri Jan 02, 2009 5:53 am

In an after job subroutine use DSGetLinkInfo() to determine whether any rows were sent to the target file. If the row count is zero delete the file and (optionally) set the ErrorCode argument of the subroutine to a non-zero value, which has the effect of aborting the job. But I don't believe you need to abort the job in this case; it is probably sufficient to log an alert (warning) that no rows were processed.

sagar deshmukh · Post by **sagar deshmukh** » Fri Jan 02, 2009 6:21 am

I have a one more requiermnt...lets say if query doesnt fetch the data then i get a blank seq. file.....but now if i dont want the job to get aborted also i dont want the blank file to get created can i do that?

ray.wurlod · Post by **ray.wurlod** » Fri Jan 02, 2009 7:34 am

Not possible within a single job. See solution in my previous post.

chulett · Post by **chulett** » Fri Jan 02, 2009 8:34 am

The file will always be created.