Setting up Job Scheduler users

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

NoteBefore you set up users in Job Scheduler, each user must have an ASE login.

StepsSetting up users for Job Scheduler

  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