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

How it works...
After you create the job, you must add at least one step and set the type of the step to the
SQL Server Integration Services Package. A job can include multiple steps, each running a
different package. An SQL Server Agent job step can run Integration Services packages that
are saved to the msdb database, or to the filesystem.
Running an Integration Services package from a job step is similar to running a package using
the dtexec and DTExecUI utilities. If you run a package from the SSIS Designer, the package
always runs immediately. While a package is running, the SSIS Designer displays the progress
of the package execution on the Progress tab. You can view the start and finish time of the
package and its tasks and containers, in addition to information about any tasks or containers
in the package that failed. After the package has finished running, the run-time information
remains available on the Execution Results tab. The account that runs an Integration
Services package as an SQL Server Agent job step requires all the permissions as an account
that runs the package directly.
There's more
Using the PowerShell platform, we can run scripts which are designed for best
administration needs, such as Backup and Restore, Agent Job Creation, Server Configuration,
and Database Object Scripting tasks.
Troubleshooting multi-server instances with
utility administration
Monitoring and managing multiple instances of SQL Server and databases is a very
challenging task. SQL Server tools are easy to use and help to manage multi-server
management through automated multi-server jobs, event forwarding and the ability to manage
multiple instances from a single-machine console. Using SQL Server 2008 R2, database
administrators can define and manage such tasks centrally using Utility Control Point (UCP).
UCP is a model that will represent the organization's SQL Server entities as a unified view.
The viewpoints are key sectors to identify which applications use that instance. This can be
handled using the SQL Server Management Studio (SSMS) tool. The following entities can be
viewed using UCP tool:
F Instance names of SQL Server (multiple)
F Data-tier applications
F Database files
F Resource utilization dimension
CPU utilization