Backup Schedule Error in DBACOCKPIT

[Former Member]

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

[manish_singh13 · Accepted solution]

Hi Swapz,

In addition for SYBASE database please check below notes also:

1802682 - SYB: ASE Error SQL7713 when executing stored procedures sp_dumpdb or sp_dumptrans

1588316 - SYB: Configure automatic database and log backups

Thanks,

Manish

[Former Member]

Hi Swapz,

Have you checked below notes:

2207239 - Exception CX_DB6_CALENDAR_ACTION in class CL_DB6_CALENDAR_ACTION

2003156 - DBA Cockpit: Job error when scheduling a job for a specific time

Thanks,

Manas