on 05-04-2009 12:52 PM
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.
We Can Schedule Adapter in Communication channel monitoing .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks to All
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.