You can schedule the job to run daily, hourly, etc ... How to Create a File or Filegroup Backup Using T-SQL Alternatively, you can use the T-SQL commands to create files or filegroups backup. BACKUP ...

The basic command to run that dump (aka backup ... version of your database backup in the defined file (in this case products.sql.tgz). Check out this article I found on TechRepublic.

Recently Microsoft released a new feature in the ultimate Power Apps user guide that will let you call SQL Stored procedures ... would you want this procedure to run within a gallery?