Schedule JDBC adapter in XI 3.0

[Former Member]

Hi experts,

Is there any way to schedule the JDBC adapter to pick the data only on First day of a month.

Thanks in Advance.

[rajasekhar_reddy14 · Accepted solution]

We Can Schedule Adapter in Communication channel monitoing .

[Former Member]

Thanks to All

[Former Member]

Hi it is possible anyway (maybe only if you have an Oracle DB) .

you can use a subselect in your JDBC Statement where you select the sysdate from dual an then extract the day and compare it with "1".

As an example:

and

(select substr((select to_char(systimestamp, 'mm/dd/yyyy HH24:mi:SS') from dual),4,2) from dual) = '01'

Regards Björn

[Former Member]

Hi,

you need to make sure your SPS is at least 19 (XI 3.0). This link will explain in detail how to do scheduling:

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

Edited by: Kai Lerch-Baier on May 4, 2009 2:04 PM

[Former Member]

Our XI 3.0 is SPS 16, means that is not possible, Thanks Anyways.

[Shabarish_Nair]

i suggest upgrading your SP level and taking advantage of the standard feature instead of going for any custom solution.

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

[Former Member]

As suggested by Shabarish you should upgrade to the latest SPS - this is anyway recommended ;o)

[former_member181962]

Hi Bandana,

yes it si possible using availability planning in communication monitoring .

Check this help:

http://help.sap.com/saphelp_nw04/helpdata/EN/45/06bd029da31122e10000000a11466f/content.htm

Regards,

ravi

[Former Member]

Hi,

Please check this sort of scheduling can be done through RWB. Here you can specify the exact date when the CC should start.

If you go in communication channel monitoring there you will find an option for scheduling.

Hope this helps.

Regards,

Siddhesh S.Tawate

[Former Member]

go to RWB-> component monitoring->Communication channel monitoring->schdule communication channel-> give the time menas after 30 days etc