August 1, 2011 at 7:24 am
I am not really sure how to handle this situation:
I have 4 separate databases within my instance of SQL Server 2005. I have a query that I run weekly in each of the databases. That query gets manually exported and then manually loaded onto a dashboard.
Anyone have any suggestions on how I could automate any portion of this? I am trying to automate this to free up time and to ensure that the information is still available if I go on vacation.
August 1, 2011 at 7:27 am
Go in SSMS, sql agent, create a new job. Paste your query there and schedule it however in it.
August 3, 2011 at 2:07 pm
It sounds like what you're really looking for though, would be something like SQL Server Reporting Services or SQL Server Integration Services, depending on the nature of the tasks.
Those two applications are much better suited for producing reports.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply