DBACockpit Scheduling Failed

[Former Member]

I've got a bit of a strange case here.

I have 4 SAP Servers, all of which are doing backups via the Planning Calendar. Yesterday I rescheduled the backups on two of the servers, and changed the way I backed up from doing a "dump" statement, to calling a Stored Proc.

The job itself says

exec sp_backup 'Transaction', 'saptools', 'Drax'

go

exec sp_backup 'Transaction', 'ERQ', 'Drax'

The two new jobs worked fine all the way up to midnight, but the midnight (and subsequent) jobs failed with

Action: SQL Script

Planned Start on: 11.09.2014 at: 00:00:00

Status: Scheduling failed

Nothing is being reported on the sybase log, nor the backup server log, which leads be to believe that the scheduler is to blame and that nothing in the SP is wrong (its been running fine, and if I reschedule a failed job it runs).

I have the following questions...

1. what caused the schedule to fail?

2. Does the cockpit write error logs?

Any answers are most appreciated.

Mike

[tilman_model-bosch · Accepted solution]

Dear Mike ,

There was an issue in ASE DBACOCKIT / Job scheduler that caused hourly jobs to not be executed on subesquent days in those hours before the time of the day when the job was created.

(E.g. you creat an hourly job at 10 am , the jobs will get executed on the follwoing days between 10 am and 12 PM , but not between 12am and 10am .

You might want to check this SAP note

1912165 - SYB: Discontinuous execution of scheduled jobs

which describes the solútion.

HTH

Tilman Model-Bosch

[Former Member · Accepted solution]

Thanks Tilman, seems like a bizarre situation, but I'll reschedule the jobs - thank you

Mike