Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Maintenance Reporting Job Issue

Author  Topic 

saurabhshrivastava20
Starting Member

1 Post

Posted - 2009-02-20 : 05:28:47
Hi,

I am facing a problem in Maintenance Job named Maintenance.SQL Reporting. This job executes at 7 AM daily and reports in 7:30 AM report.

I have checked the Activity monitor, and history also, which reflect the successful execution of this job. But after the successful execution is gets reflected in servers not reported in last 24 hours report.

I have investigated the relevent tables in MSDB which mentions that maintenance plan last updated on 1900-01-01 00:00:00.

It would be great if i can get a resolution.

Rgds,
Saurabh

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-20 : 05:58:02
Is this job related to Reporting Services?
Go to Top of Page

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2009-02-24 : 01:33:13
quote:
Originally posted by saurabhshrivastava20

Hi,

I am facing a problem in Maintenance Job named Maintenance.SQL Reporting. This job executes at 7 AM daily and reports in 7:30 AM report.

I have checked the Activity monitor, and history also, which reflect the successful execution of this job. But after the successful execution is gets reflected in servers not reported in last 24 hours report.

I have investigated the relevent tables in MSDB which mentions that maintenance plan last updated on 1900-01-01 00:00:00.

It would be great if i can get a resolution.

Rgds,
Saurabh



provide more info regarding the job...

Regards,
Ahmad Osama
Go to Top of Page
   

- Advertisement -