Richard Waymire

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.

2017-10-11 (first published: )

8,369 reads

Stairway to SQL Server Agent

Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security

Security is a confusing topic to many, especially when it comes to understanding what rights are needed to monitor and use SQL Server Agent. This article will examine the rights and roles used for SQL Server Agent, as well as the security context requirements for jobs.

2014-04-16 (first published: )

9,506 reads

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

2013-01-02 (first published: )

18,343 reads

Stairway to SQL Server Agent

Stairway to SQL Server Agent - Level 8: Using External programs with SQL Server Agent

One common usage of SQL Server Agent historically has been the ability to shell out to the operating system and run command line programs, using SQL Server Agent primarily as a job scheduler. This article will examine the pros and cons of using the SQL Server 2008 & 2008 R2 Powershell subsystem versus the CmdExec subsystem to perform tasks in the Operating System.

2011-12-28

5,507 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.

2011-12-07

4,913 reads

Blogs

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Extended Events Misperceptions: Profiler is Easier, Part 2

By

I wrote a short blog post about the misperception that Profiler was easier than...

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

By

If you read the title to this post and your first thought was That’s...

Read the latest Blogs

Forums

VS 2019 - Schema Compare - Ignore Fill Factor Not Working

By anthony.green

Got a strange one with VS2019 and a DB Schema Compare. When comparing two...

Fastest way to load a CSV file in SQL Server Table

By SQL Kidu

What is the fastest way to load a file in SQL Server Table ?...

Replication question

By pani

Im an Oracle DBA by trade and been tasked with setting up transaction replication...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers