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
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.