can any one provide me the query to fetch the below information
Obtain the following information:
list of backup jobs (full vs Differential/ sqlsafe vs native)
Time the jobs run
What drives are used
View the history of the job and give % of failures in the last week.
Thanks
DBA