DSXchange

HI,

I have a seqeunce job, that has 4-5 Job Activity within in. Sequentially arranged to run one after the other.

One of the Job activity is inserting in a table miliions of rows in oracle.

before, this job activity begins, I want to check if there is data in the table for a particular condition. THis logic is in a package.

My question is how to call package within this sequence, before this job begins. Your help is appreciated.

thanks

Typically from the command line using whatever utility exists for that using the Execute Command stage. For example in Oracle: sqlplus. And that usually with a wrapper script rather than a direct call.

Another option: create a server job that use the Stored Procedure stage (STP) to call your package. Run the job from the sequence

Yup, that's another option providing you have Server jobs at your disposal. Only reason I mention that is the original post is labelled with a Job Type of "TX".

thank you both for your reply.
I should be able to create a server job...

I do have one more question before I start changind this.

So I create a server job that calls a package which does some processing,
I call this server job in between the sequence

How do i make sure the next job does not kick start or kick starts only on success of this server job?

thank you for your help

You use a trigger on the Job activity.

This is stock standard sequence programming 101.