hi,
how can we see all failed jobs in sql 7.0 with ssms .Because i have a query to see all failed jobs but its works in sql 2005 and sql 2000.but when i try to run on sql 7.0 thn its show error
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'MSDB..SysJobHistory'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'MSDB..SysJobs'.
so will u plz tell me on which table i can check for failed jobs
thaxx
regards
jagpal singh