Scheduled Jobs and JDBC Data Source

[Gaetano De Mitr]

Hi guys,

I have create a JDBC Data Source and it working to retrive data from oracle database.

Now I need to schedule that task. How Can I schedule JDBC to retrive data?

If I create a Scheduled Jobs (based on JDBCFileLoader) I don't set JDBC Data Source...

Thanks,

[balaji_charapal]

Hi,

You can create Scheduled Data Import to import data from JDBC, search for scheduled_import_set.LIST in filter navigator and create a new Data import.

Regards,

Balaji Chara

[Ashutosh Munot1]

Hi,

See below screen shot:

Here we have to go to scheduled_import_set table and then create a schedule import and give data source name there.

Thanks,
Ashutosh Munot