Automating System Administration TasksOne of the most important advantages of the Database Engine in relation to other relational DBMSs is its capability to automate administrative tasks and hence to reduce costs. The following are examples of … [Read more...] about Automating System Administration Tasks, Starting SQL Server Agent
Automating System Administration Tasks
Creating Jobs and Operators
Generally, there are three steps to follow if you want to create a job:Create a job and its steps.Create a schedule of the job execution if the job is not to be executed on demand.Notify operators about the status of the job.The following … [Read more...] about Creating Jobs and Operators
Error Messages, SQL Server Agent Error Log, Windows Application Log
The information about execution of jobs and system error messages is stored in the Windows Application log. SQL Server Agent reads this log and compares the stored messages with the alerts defined for the system. If there is a match, SQL Server Agent … [Read more...] about Error Messages, SQL Server Agent Error Log, Windows Application Log
Defining Alerts to Handle Errors
An alert can be defined to raise a response to a particular error number or to the group of errors that belongs to a specific severity code. Furthermore, the definition of an alert for a particular error is different for system errors and … [Read more...] about Defining Alerts to Handle Errors