Setting up Job Scheduler users

Set up users so they can create, manage, or execute jobs and schedules in the sybmgmtdb database.

1. Add users to the sybmgmtdb database:

   use sybmgmtdb
   go
   sp_adduser local_login_name
   go
   

   where local_login_name is the user's login name on the Job Scheduler server.

2. Grant the appropriate roles to users:

   For Job Scheduler administrators:

   sp_role 'grant', js_admin_role, local_login_name
   go 
   sp_modifylogin local_login_name, 'add default role', js_admin_role
   go
   
   

   For Job Scheduler users:

   sp_role 'grant', js_user_role, local_login_name
   go
   sp_modifylogin local_login_name, 'add default role', js_user_role
   go