I am executing TDPSQL jobs on each of my 20-something SQL Servers. These jobs are executed through a script (either by SQL Agent or Windows Task Scheduler) on the box -- these jobs are not initiated by the TSM server. Each job edits the log file on that particular server.
I do not have access to the TSM server, but my TSM admin tells me he cannot send me a report on these since the jobs were not initiated by TSM. For example, he created a report on the B/A jobs since these are scheduled at the TSM server.
What are my options for determining if my daily SQLServer backups were successful? I am getting tired of logging into each server daily to inspect the log. Is my TSM admin's story legit? I don't understand why he can't report on the SQL jobs since the data is in the catalog (I can see the databases when I do a restore in the GUI).
We are on very recent 5.x.x.x releases of on the four TSM Servers (AIX) and TDPSQL. No plans for 6.x yet.
Any advice?
I do not have access to the TSM server, but my TSM admin tells me he cannot send me a report on these since the jobs were not initiated by TSM. For example, he created a report on the B/A jobs since these are scheduled at the TSM server.
What are my options for determining if my daily SQLServer backups were successful? I am getting tired of logging into each server daily to inspect the log. Is my TSM admin's story legit? I don't understand why he can't report on the SQL jobs since the data is in the catalog (I can see the databases when I do a restore in the GUI).
We are on very recent 5.x.x.x releases of on the four TSM Servers (AIX) and TDPSQL. No plans for 6.x yet.
Any advice?
Last edited: