Skip to Content
0
Former Member
Feb 24, 2014 at 11:32 AM

DBA planning calendar

100 Views

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.