call a package in a Sequence Job

[bella0813]

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

[chulett]

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.

[mosheh]

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

[chulett]

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".

[bella0813]

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

[bella0813]

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

[ray.wurlod]

You use a trigger on the Job activity.

This is stock standard sequence programming 101.