Skip to Content
0
Former Member
Jul 01, 2016 at 10:17 AM

Backup Schedule Error in DBACOCKPIT

379 Views

Hello,

Due to Some changes in Backup Schedule Trimmings, We have deleted our Existing Auto Backup SQL Scripts.

Now we trying to add a new Schedule but it throwing a error.

FATAL ERROR: Exception CX_DB6_CALENDAR_ACTION in class CL_DB6_CALENDAR_ACTION method ADD_PLAN line 132 / RC=Job error

Exception CX_DB6_CALENDAR_ACTION in class CL_DB6_CALENDAR_ACTION method ADD_PLAN line 132

Kernel Error ID:

WP ID: 22

WP PID: 27353

SYSID: RP1

SY-SUBRC: 1059

SY-TABIX: 0

Message: Job error

Messages from Scheduler Back-End:

Job creation failed

[ASE Error SQL7713][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Stored procedure 'sybmgmtdb..sp_sjobcreate' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

1. What has to be mentioned at SQL Script Screen, we are entering a command like below;

dump transaction RP1 using config = 'DumpThruSAPLog'

go

But in Prior SQL Script is showing like below;

--SAP DBA Planning Calendar: SQL Script

print( SELECT "starting job execution at " || str_replace(convert(VARCHAR(20),getdate(),23),"T","") )

dump transaction RP1 using config = 'DumpThruSAPLog'

go

print( SELECT "job execution finished at " || str_replace(convert(VARCHAR(20),getdate(),23),"T","") )

Is this above error is because of this wrong inputs in SQL Script. I have tried with both but same Error at last.

Please suggest further.

- Swapz