SAP Sybase 15.7 Dbacockpit (t- code DB13) daily backup scheduling status failed.

[Former Member]

Dear Experts,

EHP6 FOR SAP ERP 6.0 - SPS 09

Sybase Release: 15.7.0.050

DBSL Patch Level:  324

Windows Server 2012

Issue: Database dumps scheduling failed in DB13 calendar.

this issue is coming after extending the SAPTOOL space using below commands.

use master

go

disk resize name='saptools_data_001', size='8G'

go

alter database saptools on saptools_data_001 = '8G'

go

In DB13 calender SQL_Script is showing  in read colour.

please find the attach file of DB13 screen shot.

Action description

Action:	SQL Script
Planned Start on:	22.06.2015	at:	20:00:00
Status:	Scheduling failed

SQL script :-

--SAP DBA Planning Calendar: SQL Script

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

--SAP DBA Planning Calendar: SQL Script

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

dump database PRD using config = 'PRDDB'

go

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

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

Please help me to fix this error......

thanks in advance....................

Regards

Basha..

[sivakumar_kilari3]

Hi,

Are you able taking backup at database level using scripts.

Thanks

Siva

[Former Member]

Hello Siva,

Yes, now  I am taking backup at database level using script.

SQL command lines

dump database PRD using config = 'PRDDB'

go

and

dump transaction PRD using config = 'PRDLOG'

go

Thanks

Basha

[sivakumar_kilari3]

Hi Basha,

Can you send below command output.

sp_helpdb saptools

Thanks

Siva