Setting up SQL Server Agent Properties

Next, setup tasks are done in Management Studio in the Properties window of SQL Server Agent service:

  1. Open Management Studio and connect to the SQL Server instance.
  2. In object explorer is a node called SQL Server Agent. Right-click on it and choose Properties:
  1. The Properties window will be opened and we have to check several options. When the Properties window is open, we can go through six pages. In the first page called General, we should switch on checkboxes as it's shown on following image:
  1. Switching ...

Get SQL Server 2017 Administrator's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.