Richard Waymire


Stairway to SQL Server Agent

Stairway to SQL Server Agent: Level 1: Setup and Overview

SQL Server Agent is a Microsoft Windows service that allows a DBA to automate administrative tasks. SQL Server Agent can run jobs, monitor SQL Server, and process alerts. The SQL Server Agent service must be running before any jobs scheduled to execute automatically can be run

5 (2)

You rated this post out of 5. Change rating

2020-02-19 (first published: )

20,985 reads

Stairway to SQL Server Agent

Stairway to SQL Server Agent - Level 10: Using proxy accounts with your Jobs

Examines the proxy subsystem, which allows job steps to impersonate another user account in order to perform tasks as a user other than the SQL Server Agent service account. This is especially useful when you want jobs to run as lower privileged users of your SQL Server.

You rated this post out of 5. Change rating

2019-03-26 (first published: )

10,693 reads

Stairway to SQL Server Agent

Stairway to SQL Server Agent - Level 12: Using MSX/TSX to scale out Job Management

Examines the scale-out capabilities of SQL Server Agent, using the MSX/TSX subsystem. This capability allows you to run jobs on multiple systems and consolidate the job results/history onto a single server.

You rated this post out of 5. Change rating

2019-03-26 (first published: )

9,278 reads

Stairway to SQL Server Agent

Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems

SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job.

You rated this post out of 5. Change rating

2019-03-26 (first published: )

9,581 reads

Stairway to SQL Server Agent

Stairway to SQL Server Agent - Level 5: Understanding SQL Agent Error Logs

How to interpret and configure the SQL Server Agent error logs. Critical information about SQL Server Agent is sent to this error log, so knowing how to find it and how to interpret information in the log will save you valuable troubleshooting time.

You rated this post out of 5. Change rating

2019-03-26 (first published: )

7,629 reads

Stairway to SQL Server Agent

Stairway to SQL Server Agent - Level 7: Working with the SQL Server Agent Job Activity Monitor

The Job Activity Monitor is the system administration tool to run jobs, view job history, and enable/disable jobs. This article will also review some of the stored procedures run by the Job Activity Monitor that you can also use directly to do your own custom job monitoring.

You rated this post out of 5. Change rating

2019-03-26 (first published: )

5,792 reads

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

ASCII value of certain column is null

By SQL_Surfer

When ASCII(Column) is null, what does it represent? Is this some kind of special/control...

Need to output table data into multiple CSV files

By Mh-397891

Hello, I created the below script to output 999 rows from SQL Server table...

Changing Database page Verify on a Database in an AG

By John D

I have a database on SQL 2019 in an Availability Group (AG) and I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers