Report showing the result of a bunch of SQL SELECT queries

[nstefi1]

Hi,

I have a SQL script which I run periodically to check errors in our database.
I wanted to schedule this script to run automatically on certain dates and send me an email with the result.
Can I do this with SSRS?
Instead of defining all Datasets and design the report with all the tables 1 by 1, is there an easy way to just run my SQL script, which has a bunch of SELECT commands?
Is there any other easier solution than using SSRS?

Thank you,
Steven

 

[RTag]

You can create a job, if SQL Server Agent is running

http://www.R-Tag.com

Viewer, scheduler and manager for Crystal reports.
Send your report everywhere.

 

[nstefi1]

Can the job send me an email with the results of the queries?
I only found the way to show me if it was successful or not.
Thanks.

 

[RTag]

Yes, you can save use xp_sendmail:

http://msdn.microsoft.com/en-us/library/ms189505.aspx

http://www.R-Tag.com

Viewer, scheduler and manager for Crystal reports.
Send your report everywhere.