sender JDBC by schedule function

[Former Member]

Hi,

I will have to use Sender JDBC by schedule, for exmaple Sender JDBC is executed by specific time, every day 11pm.

is it possible to use stored procedure by sender JDBC Adapter?

any other solution will be appreciated for me.

thanks

Venjamin(YD)

[bhavesh_kantilal · Accepted solution]

Hi venjamin,

<i>is it possible to use stored procedure by sender JDBC Adapter?</i>

Yes, you can execute a stored procedure in your Sender JDBC adapter.

The only problem is you cannot execute the stored procedure of an Oracle Databse though as your Oracle Stored Procedure returns a cursor while XI expects a Result Set.

Specify an SQL EXECUTE statement to execute a stored procedure, which contains exactly one SELECT statement.

Bhavesh

[Former Member · Accepted solution]

Hi,

you mean that except for oracle, MSSQL is possible?

also, i am wondering if i will have to type update statement on the sender jdbc, it is mandatory,

any experience regarding the schedule?

thanks

venjamin(YD)

[bhavesh_kantilal · Accepted solution]

Hi Venjamin,

ASFAIK, It will work with MSSQL.

If you do not want any Update, then just use <b><TEST></b> for the update query and nothing will be updated.

Regards,

Bhavesh

[bhavesh_kantilal · Accepted solution]

Hi venjamin,

As for scheduling your Adapter goes,ASFAIK, I dont think this is possible.

You will have to use the polling interval of your JDBC adapter such that it polls over at the time that you want.

This link will answer all your answers,

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi, Bhavesh Kantilal;

you mean that poll interval is for specific schedule, evey night 11:00PM, how do i set in using poll interval for evey night 11:00PM?

maybe, first time, i may be possible, but next day 11:00PM, it will not be running exact time(11:00PM).

could you give poll interval parameter for specific time?

thanks

Venjamin(YD)

[bhavesh_kantilal · Accepted solution]

Hi venjamin,

There is no way as of now in XI wherein you can schedule your adapters. XI is still missing a scheduler to initiate sender adapters and integration processes.

Regards,

Bhavesh

[Former Member · Accepted solution]

Venjamin,

This is quite late reply, but you may find it useful in future.

You can do the scheduling stuff in ur Sender JDBC channel (if you are using that).

I did it that way. This is how i achieved scheduling...

The condition for me was to pick the records from db when status=0 and on 8th of every month at 10:00 AM. What i did was...

Select * from <table> where status =0 and day(getdate())='8' and convert(varchar(20),getdate(),8)>'09' and convert(varchar(20),getdate(),8)<'11' .

With this query keep the poll interval at 1 hour.

Explanation :

day(getdate()) = will give me the day of month.

convert(varchar(20),getdate(),8) = give me the time (actually timestamp).

Poll interval 1 hour or anything less than an hour.

Try it !!! maybe it will help you out sometime.

NOTE: I was using MS SQL server.For ORACLE the query might be adjusted a bit.

Cheers

Amit:)