Administrating the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 43

F ActiveX Script : This is useful when you need to execute a task using scripting
languages such as VBScript or JScript. This type is more useful when you need to
perform operations using SQL Server Management Object (SMO) that is designed for
programming all aspects of management.
F CmdExec —Operating System : By the name this is useful to execute any shell
commands within SQL Server environments.
F PowerShell : This is a substitute scripting method for both CmdExec and ActiveX
scripts. It's a useful scripting shell that automates the administrative and application
deployment activities.
MultiServer administration enables automated administration on multiple servers, which are
called target servers. In a MultiServer environment, the jobs will be processed on all target
servers that are first defined on a master server and then downloaded to the target servers.
The security is addressed by default by the full SSL encryption and certification validation,
which is enabled for the connection between master server and target server. To create a
MultiServer environment, we can use Master Server wizard from SSMS using SQL Server
Agent and point to MultiServer Administration.
Schedules allow the SQL Server Agent to execute the single or multiple job steps at defined
intervals. The schedule can be used to automate routine administrative tasks as a single-
step execution or as a recurring execution of desired steps, such as data ETL operations. The
execution schedule can be any one of the following:
F One-time—to execute the job step(s) at that particular defined time only
F Recurring—to execute the job step(s) repeatedly, based on a defined time interval
There's more...
To automate the administrative tasks, it is important to set up the job step execution. To do
this, you need to complete the following steps:
F One-time
F Recurring
F Execute the job step when SQL Server Agent service starts
F Execute the job step when CPU is idle
See Also
The Designing SQL Server Agent scheduled jobs for ETL processes recipe covers the usage
of 'how to manage the alerts of automated administrative tasks effectively while executing
SSIS packages.'