Archive
Archive for September, 2011
SQL Job Migration(powershall script)
2011/09/18
1 comment
[reflection.assembly]::LoadWithPartialName(“Microsoft.SqlServer.Smo”)
$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”
Categories: Common
job Migration, powershall