Restricting CmdExec Rights to Sysadmin

Check Description

This check ensures that the CmdExec right is restricted to Sysadmin only. All other accounts that have the CmdExec right are listed on the security report.

SQL Server Agent is a service available on Windows XP, Windows 2000, and Windows NT executes jobs, monitors SQL Server, and sends alerts. With SQL Server Agent, you can automate certain administrative tasks by using scripted job steps. A job is a specified series of operations performed sequentially by SQL Server Agent. A job can perform a wide range of activities, including running Transact-SQL scripts, command-line applications, and Microsoft ActiveX« scripts. Jobs can be created to run tasks that are often repeated or scheduled, and they can automatically notify users of job status by generating alerts.

Note: You must start the SQL Server Agent service before your local or multiserver administrative tasks can run automatically. SQL Server Agent is also supported on the Microsoft Windows 98 operating system, but SQL Server Agent cannot be used with Windows Authentication when you run it on Windows 98.

Additional Information

SQL Server Agent Properties

⌐ 2002 Microsoft Corporation. All rights reserved.