Required permissions
The user specified in the endpoint settings must have the following privileges on the source database:
Running with the db_owner role
If the user is a member of the db_owner database role, the following permissions must be granted:
-
On the master database:
- grant VIEW ANY DEFINITION
- grant VIEW SERVER STATE
-
On the MSDB database:
-
grant SELECT ON SYSJOBACTIVITY
-
grant SELECT ON SYSJOBS
-
Running without the db_owner role
If the user is not a member of the db_owner database role, the following permissions must be granted on the source database:
- grant VIEW DATABASE STATE
- grant SELECT
Information noteThere are several limitations that apply when running without the db_owner role. For more information, see Limitations and considerations.