Scheduled Jobs and JDBC Data Source

Gaetano De Mitr
ServiceNow Employee
ServiceNow Employee

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,

2 REPLIES 2

balaji_charapal
Kilo Guru

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
Kilo Patron
Kilo Patron

Hi,


See below screen shot:

find_real_file.png

 

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