Discussions specific to the VMware vSphere hypervisor
Post Reply
Posts: 203
Liked: 30 times
Joined: May 21, 2013 9:08 pm
Full Name: Alan Wells

Export Job Settings from SQl

Post by nunciate »

Any SQL experts out there know a query that I can run to view all of my job settings for each job type? Need to quickly review all settings on Bakcup, Backup Copy, Tape and Replications jobs.
I want to see everything including the info on the Advanced tabs that shows what days synthetic fulls run on and all that.

I wish you could add columns to the job display in the console so I could easily verify when all of my full backups occur on the weekend and adjust as needed. Right now I have to edit every job manually and go through all the tabs.

Vitaliy S.
Product Manager
Posts: 25284
Liked: 2219 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Export Job Settings from SQl

Post by Vitaliy S. »

Hi Alan,

I'm not sure about SQL Server, but it should be possible to do via PowerShell > Export Job Configuration


Product Manager
Posts: 18857
Liked: 1905 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Export Job Settings from SQl

Post by veremin »

Information regarding synthetic full backup can be gotten via the following one-liner:

Code: Select all

Get-VBRJob | select name, {$_.options.BackupTargetOptions.TransformFullToSyntethic}, {$_.options.BackupTargetOptions.TransformToSyntethicDays}

Post Reply

Who is online

Users browsing this forum: No registered users and 13 guests