On Mon, 20 Jun 2011, Gavin McCullagh wrote:
> This seems quite close
>
> SELECT Job.Name, MAX(Job.RealEndTime)
> FROM Job
> WHERE Job.Type='B' AND Job.JobStatus='T'
> GROUP BY Job.Name;
>
> but we have clients who manually trigger their own incremental (eg once per
Hi,
On Mon, 20 Jun 2011, Gavin McCullagh wrote:
> I'm looking to work out a query or script which quotes me the time since
> the last live backup (ie I don't want to include virtual full backups) for
> each of our configured jobs.
>
> Not all of our backups are scheduled, some are triggered manu
Hi,
I'm looking to work out a query or script which quotes me the time since
the last live backup (ie I don't want to include virtual full backups) for
each of our configured jobs.
Not all of our backups are scheduled, some are triggered manually, so I
need to produce a list of how long it has be
