![]() , ISNULL ((SELECT TOP (1) tape_n FROM tape_jobs WHERE tape_jobs.id = jobs.id), 0) ISNULL ((SELECT TOP (1) ref_n FROM BJobs ref_jobs WHERE ref_jobs.id = jobs.parent_schedule_id), 0) = jobs.)ĮLSE jobs.query('/JobOptionsRoot/ClusterName').value('.','nvarchar(300)') WHEN jobs.query('/JobOptionsRoot/ClusterName').value('.','nvarchar(300)') = '' THEN (SELECT. = ('DRJobOptions/LinkWithJobs').value('.','bit'), ![]() = ('/ScheduleOptions/OptionsScheduleAfterJob/IsEnabled').value('.','bit'), = ('/ScheduleOptions/OptionsContinuous/Enabled').value('.','bit'), (SELECT COUNT(id) AS Expr1 FROM dbo.ObjectsInJobs WHERE (job_id = jobs.id) AND (type = 0)) END), Select count(id) from dbo.ObjectsInJobs where (job_id = jobs.id) and (type = 0)) BCJob) (select count(id) t from LinkedJobs where job_id = jobs.id ![]() (SELECT count(id) FROM LinkedBackupRepositories WHERE job_id = jobs.id) (SELECT count(id) FROM LinkedJobs WHERE job_id = jobs.id) (SELECT options FROM WHERE id = jobs.id) AS XmlTable(o) CROSS APPLY o.nodes('/TapeJobOptionsBase/Selection/BackupSelectionBase') XmlTableFunction(c))ĬASE WHEN (SELECT count(id) FROM LinkedJobs WHERE job_id = jobs.id) 0 THEN ![]() Obj_in_job_count = (CASE WHEN jobs.type = 24 THEN Ipools.name AS incremental_mediapool_name, If you don't find it, you could recreate executing this script: Hi Denise, have checked it right now and this view exists in the Veeam Database.
0 Comments
Leave a Reply. |