Can you make reports against a SQL Servers maintenace plans, DTS/SSIS
jobs and logs in the event viewer? If so what database can I connect
my datasource to my querry this information?
Thanks
steve archer
Perot SystemsJust check the report packs provided by MS in their website. But you cant
access directly instead you need to take all the logs data to your own table
and query for report, so you can create the same using SSIS and schedule it.
Amarnath, MCTS
"captkirkrules" wrote:
> Can you make reports against a SQL Servers maintenace plans, DTS/SSIS
> jobs and logs in the event viewer? If so what database can I connect
> my datasource to my querry this information?
>
> Thanks
> steve archer
> Perot Systems
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment