SQL report for Backup Schedule details

SQL report for Backup Schedule details

Can someone provide me an MS-SQL query to output the Backup Schedule details? I'm looking for it to contain the following:

  • Enabled/Disabled
  • Every x days
  • At x time
  • WHo to notify when backup fails (email address)
  • Backup type (database an/or File attachments)
  • Backup Location
  • Retain x amount of backups
This would be super helpful for a dashboard I an writing.

Thanks