:List all Jobs needed for a disaster recovery for a jobname:
*Enter Job name:
SELECT DISTINCT Job.JobId,StartTime FROM Job WHERE
Job.Name = '%1' AND (
(Level='F' AND JobStatus IN ('T', 'W') AND
Job.StartTime = (
SELECT DISTINCT StartTime
FROM Job
WHERE
On Thu, Feb 14, 2013 at 11:04:23AM +0100, Masopust, Christian wrote:
So... some questions left:
- can the size of Selection Pattern be increased (probably without
increasing
it for all other parameter values) ?
- why are stored procedures not possible in this case?
Thanks,
Christian
On Wed, Feb 13, 2013 at 08:26:38AM +0100, Masopust, Christian wrote:
Hi,
I'd like to set up a copy job here for offsite backup (on demand) and
therefore would need
a fine SQL-query to get all jobs listed for the most recend full and all
following differentials
and incrementals. All
I'd like to set up a copy job here for offsite backup (on
demand) and therefore would need
a fine SQL-query to get all jobs listed for the most recend
full and all following differentials
and incrementals. All backups are to one single pool.
As said, the offsite backup should be
Hi Uwe,
thanks for reminding me about the query.sql :) Starting from
there I found
now a way to create a query that includes the most recent
full, the latest
differential and all incrementals since the latest
differentials (see below).
It is definitly working here for me and I'm
On Wed, Feb 13, 2013 at 08:08:34PM +0100, Masopust, Christian wrote:
:List all Jobs needed for a disaster recovery for a jobname:
*Enter Job name:
SELECT DISTINCT Job.JobId,StartTime FROM Job WHERE Job.Name = '%1' AND (
(Level='F' AND JobStatus IN ('T', 'W') AND
Job.StartTime = (