Event Manager Mail Merge Processing

Outline: Technical Installation Preliminary Actions Before following the instructions contained in the document you need to have installed Event Manager and configured an email please refer to the Event Manager user guide to install and configure Event Manager. User Guide for Processing Mail Merges Use this section to understand how to use the Event Manager…

Read More

Use WIndows Power Shell to Script SQL Jobs from one instance to another

Open Powershell Execute Invoke-Sqlcmd Execute $output = "d:\ScheduledJobs.sql" Execute Remove-Item $output Execute Set-Location SQLSERVER:\SQL\localhost\DEFAULT\JobServer\Jobs Execute # loop through jobs appending output Lastly Execute dir | %{$_.script() + "`n`nGO`n`n" | out-file -append $output} Do the above one line at a time then take the output ScheduledJobs.sql go to the new server and open Management Studio and…

Read More

Rough-cut capacity

Rough-cut capacity, also known as rough-cut capacity planning or rough-cut capacity analysis, is a high-level capacity planning technique used by businesses to assess their ability to meet demand based on available resources. It provides an approximate estimate of whether the existing capacity is sufficient to meet the projected demand or if adjustments need to be…

Read More