DBA planning calendar

[Former Member]

Hello,

I'm getting several errors with scheduled jobs. But It's so rare, sometimes it works, sometimes not.

I've scheduled the backup of transaction log, DB, and master.

--SAP DBA Planning Calendar: SQL Script

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

dump transaction PRD using config = 'PRDLOG'

go

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

I've defined a store procedure for backup.

The job for master backup, It always fails.

--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 master using config = 'master'

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","") )

I´ve checked partition space but this isn't the reason.

[former_member188883]

Hi Ruben,

Could you also share following details

1) What is the Sybase Version

2) How many app servers does production server has

3) Have you applied all the dbacockpit related notes ?

Regards,

Deepak Kori

[Former Member]

Hi Rubben,

Is DBA Cockpit Correction Collection at latest version?

I allways run the dump database command in Planning Calendar like this:

use master

go

dump database master using config = 'master'

go

in order to avoid any issues. Please let me know if it helps.

Regards,

Ionut