Easy to master the way of database management--operation and maintenance patrol six (operating condition)

Objective

To do daily inspection is an important step of database management and maintenance, and it is necessary to register each inspection date and result, and may need to make a inspection report.

This series is designed to address some common problems:

• I don't know what to patrol.
• Don't know how to get a quick checkup
• Machine Too much physical examination trouble
• Difficult to generate reports, no visual rendering of results

Many of the business functions and database functions of SQL Server need to be done through jobs (such as previously mentioned backups, publish subscriptions, etc.). It can be seen that the success of database job execution is also critical to the entire system. Most of the situation can be notified by the job notification or monitoring function to timely alarm, the same in each inspection also to confirm the operation of the operation is normal.

Job Log

The job log can be visually rendered in the SQL Server Administration tool, and can be viewed through the job Activity monitor, view execution history, and more. The SQL Expert cloud also integrates this functionality to see how jobs are performed on the Jobs page.

　　

After clicking on a job, you can also view detailed steps and implementation of the job.

　　

Summarize

Work is an important part of the system, the inspection should include the operation of operations, as the industry errors, should be dealt with in a timely manner.

　　

Easy to master the way of database management--operation and maintenance patrol six (operating condition)