I have a table. Record is getting inserted through application not a daily basis.
I need a scheduler which will fetch records from this table and will upload in another table.
Here my requirement is since in this table record is not getting inserted frequently, i do not want to fecth this table data in a regular interval through scheduler.
I want to fetch this table only once by some other mechanism say. How i will do it.
Amin is to reduce frequent db fetch call.