Set up users so they can create, manage, or execute jobs and schedules in the sybmgmtdb database.
Before you set up users in Job Scheduler, each user
must have an ASE login.
Setting up users for Job Scheduler
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.
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
