DSXchange

Hi,

I have an oracle SP and I want to execute in every 30 mins. Hoping DS should be able to handle this through the so called 'Stored Procedure' stage. But when i run it is telling that there are no output ports (why shall i define any port). Also I do not want to write a UNIX script for this, though i can.

If someone has executed this scenario only, pl. response.

I can see replies that this has been already sent across. But i didn't find anything concrete so far.

Thanks
Gupul

To simply run a Stored Procedure every X minutes, why not just setup an Oracle 'job' to do that? There's really no need for DataStage to do something like that.

hello can you define upper limit for your procedure, like until what date you want your procedure to run say upto say 01-01-2010 in interval of 30 mintues.



i have an idea like you define one job with stored procedure stage and call that job from other job using job control and sleep statement, hope that may help.