Database Reference
In-Depth Information
How it works...
The role of the SQL Server Agent is to handle the scheduling of tasks and communicate the
results to relevant alert resources.
For the purpose of our recipe, the key functionality of SQL Server Agent service is classified
as relics, which can be used to combine the alerts and communication to facilitate proactive
administration. The SQL Server Agent service is the key control. First, we must understand the
functionality of how these relics are governed by the service and then begin the process of
configuring the service for automated administration.
The security context of a job step execution has a specific entity. For instance, if the job
step specifies a proxy, the job step then runs in the security context of the credential of the
proxy. If no proxy account is defined on the SQL Agent, then the default execution of that job
step runs in the context of the SQL Server Agent service account. To facilitate the proactive
administration methods, the agent functionality is differentiated into jobs, schedules,
operators, alerts, and proxies, as shown in the following screenshot:
Search WWH ::
Custom Search