How To Save SQL Results to Excel on Schedule

Respondida

Apollo Cherniak

• 15 de octubre de 2019 14:35

I've got a scenario where I'd like to validate if a table has been modified in the last 5 minutes, and if it has, run a SQL report and save the results to an Excel file on the network.  There isn't a whole lot of activity in this table throughout the day, but it is overwritten each time it is changed, so I want to capture a snapshot at the time it is changed.  There is a linked table that has a timestamp for when the table in question was updated, so that will be my condition.

My question is more geared to how to save the results of a SQL report to an Excel file on a schedule.  Thanks.

Vote

0

• Comentario oficial

  

  Yaremi Miranda Lopez

  • 17 de febrero de 2020 15:54

  Hello Apollo,

  You can achieve this with the add-on B1 Usability Package with the File exported module. Here is a video that explains how it works.

  https://youtu.be/Yzj2ceRk9Io

   
• 

  Apollo Cherniak

  • 16 de octubre de 2019 15:51

  bump

Iniciar sesión para dejar un comentario.