SAP Knowledge Base Article - Preview

2484078 - sp_sjobcontrol fails with Msg 553, Level 16, State 1

Symptom

When you execute the following command:

exec sp_sjobcontrol @name='jname=<jobname>', @option='disable' 
go

You may receive the following error:
Msg 553, Level 16, State 1: Server 'SERVERNAME', Procedure 'sp_sjobcontrol', Line 580: The number of parameters/variables in the FETCH INTO clause does not match the number of columns in cursor 'sjob_enable' result set. (return status = 0)


Read more...

Environment

Adaptive Server Enterprise 16.0 and above

Product

SAP Adaptive Server Enterprise 16.0

Keywords

sp_sjobcontrol Job Scheduler 553  , 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.