ExecuteSQL reads data from database an infinite number of times

vscherbakov — Wed, 27 Jun 2018 18:32:54 GMT

Processor reads data from database an infinite number of times.
How can I limit this so that he reads the data only once and does not repeat?

Re: ExecuteSQL reads data from database an infinite number of times

Shu_ashu — Sun, 18 Aug 2019 01:12:10 GMT

@Vladislav Shcherbakov

You can change the schedule of ExecuteSql Processor

Right Click --> Configure --> Scheduling tab

Executesql either trigger based on Timer driven (or) cron driven, as shown in the above RunSchedule 1111111110 sec means the processor trigger once 1111111110 sec. you can use like 1 min,1 hr instead of specifying in sec.

Cron driven use this link to make your cron expression then change the scheduling strategy to cron driven and keep your cron expression in Run Schedule.

ExecuteSql processor doesn't store the state if you want to incrementally pull the data then use either incremental fetch using QueryDatabaseTable (or) Generate Table Fetch processors as these processors stores the state based on max value column provided and pulls only the changes made after the store state.

Re: ExecuteSQL reads data from database an infinite number of times

vscherbakov — Wed, 27 Jun 2018 21:25:26 GMT

Perfect! Thanks!
I'll try QueryDatabaseTable for it. It'll be better!

question Re: ExecuteSQL reads data from database an infinite number of times in Archives of Support Questions (Read Only)

ExecuteSQL reads data from database an infinite number of times

Re: ExecuteSQL reads data from database an infinite number of times

Re: ExecuteSQL reads data from database an infinite number of times