Scheduling sender JDBC adater

[Former Member]

Hi All,

I'm working on XI 7.0 . I have configured file and JMS adapter scheduling .

But I have a doubt whether we can <u>schedule Sender JDBC adapter</u> to poll daily on specified time.

Thanks,

venu

[Former Member]

Hi venu !

you need to give the polling interval there in secs

have a look at the following

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

In the sender communication channel you have to give

<b>606024*1=?? in Poll interval for 1 days.</b>

Else

You can schedule your communication channel if your SP is 19 and above. Please see this weblog for some information on this:

/people/shabarish.vijayakumar/blog/2006/11/26/adapter-scheduling--hail-sp-19-

check this link also

Thanks!!

Questions are welcome here!!

<b>Also mark helpful answers by rewarding points</b>

Regards

Abhishek Agrahari

Message was edited by:

Abhishek Agrahari

[Former Member]

Thank you.

I also known these aspects , but I expected any one who worked and confirmed the same.

since JDBC adapter drivers are not installed I'm not able to test in my landscape.

venu

[bhavesh_kantilal]

We have a Sender Jdbc adapter scheduled and working on our production without any issues!

We just ensure 2 things,

1, We have selected option Disconnect from DB after each message processing.

2. In the Sender JDBC adapter the poll interval is set to 300 Seconds and the adapter is made active only for one minute.

The Sender JDBC adapter polls once when it becomes active at the particular time of the day and then even before the 300 seconds polling is reached the adapter is inactive.

Regards

Bhavesh

[Former Member]

Hi

You can schedule the JDBC Adapter in a similar fashion.

Refer to my answer for detailed description

Thanks

[nisarkhan_n]

i think we have an option in 7.0, just check the adapter scheduling there i think you can do it.