Richard Waymire

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

by Richard Waymire

SQLServerCentral.com

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: 2011-12-28)

6,836 reads

Discuss

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

by Richard Waymire

SQLServerCentral.com

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.