Script to abort the job

[Poornagirija]

HI folks, :D
We are working on Ds 7.5.1.

we have one job.Let me explain that.
The source is xl sheet.so we are using unix script (that includes java script) which will convert xl to csv format.
we are calling the script in before subroutine.
This is followed by one job which will populate the data to a table.

We have one minor issue.sometimes while converting xl to csv we have 0 bytes in the source file.so no data is populated to the table.
We are interested to do the following...
If there is no data in the file then the job has to be stopped at the stage itself or it should get aborted so that we can send an email notification.

The unix script will send a mail if there is no data but it wont stop our job.

Is there anyway that our script can abort the job itself.
Or can we do that in routines?

Any suggestions will be helpful to us.

Many thanks in advance.

[ArndW]

The before-job routine will automatically fail the job if the return code from the shell is non-zero. So make your shell script return an error.

[kumar_s]

Create a shell script to check the size of the file and based on the return code direct the sequence to act accordingly.

Code: Select all

[[ -s $IFM_INPUT_001 ]]

RC=$?

if [ $RC -ne 0 ] ; then
 return 0
fi
if [ RC -eq 0 ] ; then
  return 1
fi

Use the above to check the size. If the filesize is 0Kb then the above will return 1 (error). 'On Error' from the Execute command trigger the email notificaiton.
Better not to abort.

[Poornagirija]

HI ArndW,

Thanks for your suggestion.

we will do that..

[Poornagirija]

Hi kumar,
Thanks for your script :D

[roy]

Hi,
Another option might be:
get the link row count of the relevant link in a UserVariable stage after the reading job finishes (using DSGelJobLinkInfo()) then in a nested condition stage upon zero rows trigger notify via mail (or what ever) and finish and otherwise trigger to do the process you need.

In any case zero rows will most likely make no effect on anything.

And most important you will not abort the job

IHTH,