But how do we know if the backup completed without error?
At the beginning log the qualified job name into a data area.
Right before the RESTART tag you could log the timestamp into a different
Later on something else could check that timestamp data area and see if
it's longer than it should be. If so, it could retrieve the job name from
the other data area and use the sql services to analyze the joblog.
Hopefully you don't still spool up joblogs.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.