no, with just SQL data you don't have what you need.
What do you mean DiRT just "stopped"? If there were errors in the backup that gets written through to the event log always. If you took the task out of the Windows scheduler then there's no much DiRt can do to warn you of that fact. DiRT is not, however, just going to fail on a scheduled backup without warning via the event log.