web service to call sequence job

stivazzi · Post by **stivazzi** » Thu Jun 08, 2006 12:59 am

hi to all!
is it possible to call a RTIenabled sequence job from a java (or c#) web service? or can i only call some kinds of jobs? parallel or server?

Thanks a lot!
Andrea

ray.wurlod · Post by **ray.wurlod** » Thu Jun 08, 2006 1:12 am

Check the job properties. Is there an RTI Service Enabled check box? That is your answer.

For those who don't have RTI, the answer is that RTI is available for server and parallel jobs, but not for job sequences. The reason is that, if you publish a DataStage job as a web service, it must have some mechanism for receiving data from, and returning data to, the client of the web service. Job sequences do not, of themselves, process data.

stivazzi · Post by **stivazzi** » Thu Jun 08, 2006 1:14 am

>>Check the job properties. Is there an RTI Enabled check box?

that's why i was asking this...
i can see RTI enabled check box only in server jobs...
does it mean i can call only server jobs, from a web service?

chulett · Post by **chulett** » Thu Jun 08, 2006 7:33 am

It means you can 'RTI enable' Server, TX or PX jobs but not Sequence jobs.

sud · Post by **sud** » Thu Jun 08, 2006 9:51 am

Hey,

This post, reminds me of a similar requirement. Would really appreciate if anyone can throw some light on this.

We had a requirement where we wanted to run a job on-demand, when certain changes were made to a field in a database. It is something like, a field's value is changed from null to 'ready' and u start your job. We dealt with this by creating a looping job which checks the state everytime and starts the on-demand job whenever necessary.

Is there a better way of doing this ? Through web-service calls if possible ?

We are using Oracle databse.

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Thu Jun 08, 2006 3:14 pm

Old design

Code: Select all

stage1 ----> stage2 ----> stage3

or some variant thereof.

New design

Code: Select all

RTI_Input ----> stage1 ----> stage2 ----> stage3 ----> RTI_Output

or, more likely (if the web service is to deal with XML documents)

Code: Select all

RTI_Input ----> XML_Input ----> stage1 ----> stage2 ----> stage3 ----> XML_Output ----> RTI_Output

You then publish the RTI-enabled job (which becomes an always-running job, perhaps with multiple instances) as a web service. It's all in the relevant manuals.