Solution : https://service.sap.com/sap/support/notes/142848 (SAP Service marketplace login required)
Key words :
#tasks drop table #tasks set nocount onendgo/ end, runstatus = 0 update #tasks set status_desc = 'successful', runstatus = 1 update #tasks set status_desc = 'retry', null update #tasks set status_desc = 'failed', subsystem update #tasks set #tasks, @tempdate3 int create table #tasks, end select @tempdate3 = @tempdate2 insert, lastruntime update #tasks set runstatus = 999, sap_mon_all_tasksgocreate procedure sap_mon_all_tasksasbegindeclare @tempdate datetime, @tempday < 10 begin select @tempdate2 = cast
Related Notes :
| 142657 | No Log Found for Scheduled job even with success |
| 142451 | Job scheduled for Immediate Start are not enabled |
| 139945 | SAP Database Monitor for MS SQL Server |