DSXchange

Hi,

We have source feed as XML Messages, so the data feed is continuous.
So our requirement is to have that extraction job continuously running for lets say 8 hours, in result it will extract and load data in Staging area continuously.

I am aware of two work around -
1. To schedule the job e.g. after each 30 mins from monday to friday
2. Using UNIX script repeats the job execution

I dont want to use this two options. Is there any built in function or scheduling facility that will allow me to run that job continuously?

Regards!
Amarnath

Are you sure that your job will finish within the 30 mins? What if it over-runs?

In the sequencer, you can make the job sleep for "30 - x" seconds, where x is computed using the job start and finish time.

Alternatively you can make your input read a pipe making it realtime load.

Use any third party tool like Control-M

Hi keshav,
I dont have Control-M for scheduling. And I am avoiding use of UNIX scripting for keeping maintanance easier of my jobs.

Sainath,
I have tested that job gets finished in 10-13 mins everytime still I am keeping a buffer of 15-17 mins more.
I am looking in sequencer for this sleep time option.
Can you please provide me some more details on that.

Thanks,
Amarnath

Why not create the job as a "WISD" or real time job, expose it as a service? Then it truly can "execute continuously" and process messages in real time. Depends on what exactly these "messages" are and how they are (or could be) delivered.