Hi @Jayaprakash R ,

There is plenty documentation on this topic, you can read the following articles / documentation:

• Parallel Batch Processing in OutSystems
• Mastering Timers and Data Synchronization in OutSystems: A Deep Dive
• How to Manage Heavy Timers in OutSystems
• How to Master Asynchronous Processes in OutSystems?
• Masterclass: 1.1 Batch processing using Timers

Yes, Timer is perfect choice for your needs :)

https://learn.outsystems.com/training/journeys/async-processing-timers-586/best-practices-on-timers/o11/803

Hi , You can follow the steps 
 Create a Timer

• Go to Logic → Timers → Add Timer.

• Name it something like Timer_XYZ.

2. Create a Server Action for Timer Logic

• Right-click on the Timer → Create Action.

• This action will contain your batching logic.

3. Define Batch Parameters

Inside the Timer’s action:

• Create local variable:

  • BatchSize = 100 (or any number based on volume).

  • Offset = 0

4. Loop Through Batches

Use a Loop with Exit Condition like:

plaintextCopyEditExitCondition = IsEmpty(SourceData)

Inside the loop:

• Fetch Batch from SourceEntity:

  • Use Aggregate or Advanced SQL with:

    • MaxRecords = BatchSize

    • StartIndex = Offset

• For Each Record in Batch:

  • Create a new record in TargetEntity using CreateTargetEntity.

• Increment Offset:

  • Offset = Offset + BatchSize

5. Set Timer Interval

• Go to Timer properties:

  • Schedule: Define how often it should run (e.g., every 10 minutes).

6. Publish and Test

• Publish the app.

• Run the Timer manually from Service Center to test.

• Check data appended in TargetEntity.