ApexSQL Knowledgebase: What are the required permissions to document jobs?

LINKS

General

ApexSQL Audit
ApexSQL Clean
ApexSQL Data Diff
ApexSQL Debug
ApexSQL Diff
ApexSQL Diff API
ApexSQL Doc
ApexSQL Edit
ApexSQL Enforce
ApexSQL Log
ApexSQL Log API
ApexSQL Recover
ApexSQL Refactor
ApexSQL Script
ApexSQL Source Ctl
ApexSQL SSIS Compare

Knowledgebase Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly.

FAQs

Quick answers to common questions.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools.

Online Documentation

All of our help files for download or convenient viewing online.

Videos

Watch product demos, training videos, or tutorials of our products' main features.

ApexSQL Knowledgebase

Tips and How-to Articles for ApexSQL Tools

What are the required permissions to document jobs?

DESCRIPTION
The minimum permission requirement for jobs documenting are described in this article.

SOLUTION
Jobs are the part of SQL Server Agent and are accessed in different way comparing to regular database objects. Account which is used for jobs documenting should be granted the following permissions:
1. Login used to connect to SQL Server must be part of sysadmin server role. Here is the shot for that. In any other case no jobs will be documented:

2.Also the user related to this login must have db_creator role set on a database that is selected. Nothing specific needs to be set for msdb database.

AUTHOR
Dmitriy Dyubchenko

LAST REVIEW DATE
10 August 2009

Labels: ApexSQL Doc

posted by Dmitriy Dyubchenko on Monday, August 10, 2009

0 Comments: