SAP Knowledge Base Article - Preview

2984063 - Msg 19083: Login with js_admin_role can't disable job scheduler job with 'all_users' option.

Symptom

A login with js_admin_role can't disable a job from another login using 'all_users' option.

sp_displaylogin

suid: 17
Loginame: prjaman
Login Profile: DBA_login_profile

sp_securityprofile 'attributes','login profile', DBA_login_profile

Name Value
-------------------- -----------------
login profile DBA_login_profile
auto activated roles js_admin_role
auto activated roles mon_role
auto activated roles oper_role
auto activated roles sa_role
auto activated roles sso_role

sp_sjobcontrol @name='updtInxStats', @option='disable,all_users'

Msg 19083, Level 16, State 1:
Server 'myserver', Procedure 'sp_sjobcontrol', Line 465:
Procedure sp_sjobcontrol, you do not have permission to access the specified scheduledjob, job, schedule or running job - @name.
(return status = -19083)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.
  • Job scheduler

Product

SAP Adaptive Server Enterprise 16.0

Keywords

19083,all_users,sp_sjobcontrol,disable,job scheduler , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.