ADMINISTRATORS
As an Administrator, you have complete access and control of all SQL Enterprise Job Manager sections and features. A key characteristic of Administrators is that you can perform all Administrative tasks such as adding new users for example, and defining their roles as other Administrators, or as Users or Read-Only users.
Among the multiple tasks that you can perform as an Administrator, the following are just an example of the main features available to this user role:
- Select multiple instances and register them for monitoring.
- Change the connection credentials used to connect to your monitored instances.
- Remove/delete those instances that you no longer want to monitor.
- Start the SQL Server Agent Service for several instances.
- Edit the properties of a selected job.
- Add new jobs, edit their schedules, and perform actions on them such as start, stop, enable, disable, or remove them respectively.
- Access the Administrative section of SQL Enterprise Job Manager where you can manage your licenses, add/import instances, manage users, change job grooming settings, manage collection interval settings, configure alerts notifications, and subscriptions to alerts. Go to Administering your SQL Enterprise Job Manager for more information about what is available on this page.
USERS
As a regular user, you can access all the SQL jobs and instances management functionalities in SQL Enterprise Job Manager but you cannot access or perform any of the Administrative tasks located on the respective tab.
Regular users can perform tasks such as:
- Register multiple SQL Server instances for monitoring.
- Change the connection credentials of those SQL Server instances that you are monitoring.
- Remove/delete those instances that you no longer want to monitor.
- Start the SQL Server Agent Service for several instances
- Access the editing properties window of a job and make the necessary changes.
- Add new jobs, edit their schedules, and perform actions on jobs such as start, stop, enable, disable, or remove them respectively.
READ-ONLY USERS
As a Read-only user, you can access all SQL Enterprise Job Manager tabs except the Administration tab. You can get an overview of the Home tab, view Scheduled jobs, their job history, and access the list of registered instances but you are restricted to perform the following tasks:
- Editing/adding new jobs.
- Adding new instances to monitor or disabling instances that you do not want to monitor anymore.
- Rescheduling jobs.
- Performing actions on jobs such as start, stop, enable, disable, or delete.
- Changing job´s properties, although you can access a read-only version of these properties.
- All options available in the Administration tab are not available for this user role.