Job webhooks, HTTP notification


#1

Adding a webhook notification for each successful / failed backup would be a great idea, when you need a close monitoring of databases backup.

I assume it’s possible to do some type of HTTP notification with “Custom Scripts” but the documentation for this is poor, It’s unclear if this runs after each database backup or after each job, You also can not get a status environment variable.

Any suggestions?


#2

Hello,

Thank you for the feature request. Please give us some time to consider it.


#4

This would be great to be able to call a custom URL/Webhook with parameters upon completion of a backup job.

This would help us integrate with our status board to monitor the status of the backups.


#5

Hi Ruben_Nunez,

Thank you for your request, we have forwarded it to our dev team for consideration.

Thank you.


#6

I want to second this. I would also suggest an RSS feed maybe? That way we can pump it into Slack or other RSS readers (MS Teams, MS Flow, MS Power Apps) to alert/manage.


#7

Hello Brett_Slaght,

Thank you for your request, we’ll consider it.

Currently, you can call webhooks via PowerShell running .bat script before/after backups. To do it, please add the following string into a .bat script.

powershell Invoke-WebRequest -UseBasicParsing -Body ‘{ JobName:MySqlBackup, IsSuccess:%SQLBAK_JOB_SUCCESS%}’ -Method Post -Uri “https://webhook.site/1d1d3ff2-96d6-44b2-ba30-ac95a8265ac8

SQLBackupAndFTP


#8

@Alexander Thank you,

This might just do it, but does any documentation exist describing all placeholders (like %SQLBAK_JOB_SUCCESS%) that can be used? Can this be done on multiple databases backup, where some fail and some are successful?


#9

Hi Eli_Perlstein,

You can find all the available options can be found at “After backup” window as shown in the screenshot below

SQLBackupAndFTP

Also, could you please clarify, do you prefer to add any other variables? If yes, which should be added, and what should they contain?


#10

Hi, I think I’m being a little dense. I was trialling this software and need a way to send a HTTP webhook off, I’m fine with the script approach but I don’t seem to have this option when performing a MySQL backup, I’ve not tried other types of backups.

I’m running the latest version from the website, I purchased a license (standard) in case that was the reason why but with no success. I’m only using this for personal purposes on Windows Server 2016.

What might be the reason this option doesn’t present itself to me?


#11

Hi Howard_Lince_III,

Thank you, we’ll fix it.

Sorry for the inconvenience.


#12

Thanks for the response Alexander,

is there a version I can roll back to that has this? Do you know the timeline for the fix?


#13

Hi Howard_Lince_III,

We have added the ability to enable scripts for MySQL\PostgreSQL\phpMyAdmin into the Alpha edition http://sqlbackupandftp.com/download/alpha Could you please test it?

Sorry for the inconvenience.


#14

Hello @Alexander, Thanks for the quick response.

I’ve installed alpha and written pre & post scripts and happy to inform both are running as expected at this time with MariaDB (MySQL). Thank you so much for your support!

Now if only I can find a system backup as friendly as this software. :thinking:


#15

Hi Howard_Lince_III,

That’s great! Thank you.

With SQLBackupAndFTP, you also can backup your local files and folders. Just add the needed files and folders at the “Backup folders” section.

SQLBackupAndFTP