Daily a JDBC sender channel should query database and pick up newly created records

[Former Member]

Hi Experts,

We are working on database to ECC scenario using PI 7.4 single stack.

We have  to do job scheduling on sender jdbc channel.

The requirements is channel triggered the data daily twice at 5 AM and 11 PM

I go through SCN but i didn't for single stack.

Please any one provide step by step process

Thanks,

Raju

[udo_martens]

Hi Raju,

I think the easiest by staying in the standard would be to setup 2 channels, start them at 5 and 11, and put an interval of 86400 seconds = one day.

Inside the DB you put a read-sign (one column where 'X' means already read). Then you put your query statement and a corresponding update statement (to set the read sign).

/Udo

[Snavi]

Hi Udo,

I personally think maintenance would be an issue, if there is an outage in the system, someone has to be available at the specified timings to start the channels, and if there are more of these kind of schedules

[Snavi]

Hi Raju,
you can create the jdbc to ecc scenario and schedule the sender jdbc channel to run at the scheduled intervals.
for help on channel scheduling , please go through the following link

http://help.sap.com/saphelp_nw73/helpdata/en/48/b2dfeb6b156ff4e10000000a42189b/content.htm