Run Server Job based on Stored Proc Result

[Wholsea]

Scenario:

Oracle Stored Procedure, returns a 1 or a 0.

I have a server job that Runs the proc, takes this result, and stores it into a local file on the server.

I have another job that takes this file and FTPs it to another server.

I only want the FTP job to run if the procedure returns a 0.

I can't seem to find a good example, and the online docs are no help at all.

Thanks!

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[Wholsea]

Using DataStage Designer 7.5

Procedure is in an Oracle 9i database.

Oracle is on UNIX, DS is on W2K.

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise