Richard Waymire

All authors

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-03-26 (first published: )

6,920 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-03-26 (first published: )

10,743 reads

All authors

Blogs

Regression Testing: DAX User Defined Functions

By

User Defined Functions is a new feature in PowerBI currently in public preview. There...

The fundamental requirements of a reporting system

By

There are some fundamental boxes that your reporting system must tick. ✅ The figures...

Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management

By

When it comes to managing complex database environments, having the right monitoring solution is...

Read the latest Blogs

Forums

SQL MI Next-gen general purpose tier

By SqlAdmin001

Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation...

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

The Last Good DBCC Run

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Good DBCC Run

Visit the forum

Question of the Day

The Last Good DBCC Run

I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?

See possible answers