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: )

21,477 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: )

11,937 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,900 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,866 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: )

8,221 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: )

6,039 reads

Blogs

How to find free space in Azure PosgreSQL

By

I wanted to figure out how big (or approximately how big) my dump file...

T-SQL Tuesday #180: Good enough is perfect Roundup

By

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Using SQL Compare with Read-only Access

By

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Read the latest Blogs

Forums

Announcing SQL Server 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Announcing SQL Server 2025

Running Steve's Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Running Steve's Code

New SQL Server 2022 Functions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item New SQL Server 2022 Functions

Visit the forum

Question of the Day

Running Steve's Code

Can you run this code in any of your SQL Server 2019 databases without error?

CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
    
        SELECT Consumer_ID ,
               Trend_Category ,
               Bit_Trace
        FROM    NewWorldDB.dbo.MarketTrend;
    
GO

See possible answers