November 14, 2005 at 9:51 am
I want an HTML report generated weekly for my SQL Maintenance plans. I see all kinds of people who agree that this is a good thing but can't find a step by step on how to atually do it. have no idea how to set up report generation, let alone scheduling it. Could someone get me started in the right direction?
Thanks.
November 15, 2005 at 8:18 am
take a look at web assistant wizard under tools. its will walk you through creating the HTML report and scheduling the job.
I use this query for my db maintenance plan report on a daily basis:
select a.database_name as [Database], b.plan_name as [Maintenance Plan],
c.name as [Job Name]
from msdb..sysdbmaintplan_databases a, msdb..sysdbmaintplans b,
msdb..sysjobs c, msdb..sysdbmaintplan_jobs d
where a.plan_id = b.plan_id
and a.plan_id = d.plan_id
and d.job_id = c.job_id
order by a.database_name
November 15, 2005 at 8:38 am
Thanks for the reply but I still am not getting it. What database am I supposed to select in the web assistant wizard? MSDB? When i try to complete the web assistant wizard it returns "error 16805 SQL Web Assistant: Could not execute the SQL Statement"
November 15, 2005 at 9:07 am
Ahh it seems I have this issue, thanks again.
http://support.microsoft.com/default.aspx?scid=kb;en-us;834116
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply