$server = New-Object Microsoft.SqlServer.Management.Smo.Server(“localhost”) $scripter = New-Object Microsoft.SqlServer.Management.Smo.Scripter($server) $jobs = $server.JobServer.get_Jobs() | Where-Object {$_.Name -notlike “sys*”} $script = “” foreach($job in $jobs){ $script += $job.Script() + “GO`n” } $script » “c:\sqljobs.sql”

http://www.sqlservercentral.com/blogs/sqlservertips/archive/2011/06/23/taking-script-of-sql-server-jobs-for-migration.aspx

Comments (archived from WordPress)

Simon Cho · 2011-09-18

Set-ExecutionPolicy Unrestricted