Hello Everyone
I have not been an admin on a SQL 2000 box in some time now, I cannot remember, or find in the list of tables in the MSDB database, the name of the tables where the DTS information and the SQL jobs are being stored.
I need to query all the info from the table to create a report of the failed SQL jobs. I have just taken over a server that has many jobs that are failing.
My memory is failing me, nor can I find the tables using Query Analyzer
Thanks
Andrew SQLDBA