SAP Knowledge Base Article - Preview

2698029 - Error 19084 raised when enabling a scheduled job - SAP ASE

Symptom

  • Cannot enable a scheduled job that has a shared_run property but owned by another user and is in disabled state.

sp_sjobcontrol @name='schedjob1_juser1', @option='enable'
go

Msg 19084, Level 16, State 1:
Server 'sp2pl3', Procedure 'sp_sjobcontrol', Line 630:
Procedure sp_sjobcontrol, you do not have permission to modify information for
the specified scheduled job, job, schedule or running job.
(return status = -19084)

  • Properties

     sjob_id: 14  name: 'schedjob1_juser1'
     owner          : juser1
     created        : Sep 24 2018  9:20PM
     state          : disabled
     job name       : 17 - 'job1_juser1'
     schedule name  : 17 - 'sched1_juser1'
     properties     : shared_run
     server         : sp2pl3
     -- job --------:
     description    :
     owner          : juser1
     created        : Sep 24 2018  9:08PM
     properties     : shared
     -- schedule ---:
     description    :
     owner          : juser1
     created        : Sep 24 2018  9:15PM
     properties     : shared
     repeating      : every 5 minutes
     starttime      : 07:16
     endtime        : 23:59
     startdate      : 24 Sep 2018


Read more...

Environment

Adaptive Server Enterprise (ASE) 15.7 and higher

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

19084, sp_sjobcontrol, job, scheduler, enabled, disabled, admin , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.