Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_cs
Posting Yak Master
223 Posts |
 Posted - 2011-10-03 : 06:58:22
|
| Is there any easy way to link backyp history the execution of an agent job?I'm trying to create a report to return the backup info from the last time a job was run. The only way I can see of doing this at the moment is to filter the backup start and finish date with the start and finish time of the job.This might be the only way but wondered if anyone had any ideas.Junior DBA learning the ropes |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-10-03 : 07:02:41
|
| Not sure if its the right answer to the question you are asking, but Backup History is here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300#273265 |
 |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-10-03 : 07:17:45
|
| Thanks for the link.I can get all the information I want about the backups themselves, but I wanted to know if there was a link from the backup history tables in MSDB to the sysjob tables.As I say I couldn't see anything obvious so I might just have to filter it on the dates.Junior DBA learning the ropes |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-10-03 : 09:46:42
|
| No, the Backup History Tables have no knowledge that they are run from a scheduled task / job, rather than manually or somesuch.It might be that the scheduled task explicitly sets up a Description or Name on the backups, if so you could use that as a means of identifying them in the Backup History Table, but there would be nothing to stop someone "mimicking" that in a manual backup, so-to-speak. |
|
|
|
|
|
|
Backup history report