Run report from script and email

A

Annette

I would like to be able to run a report from a scheduled script. For
example, the script would run the report at 5:00am. The parameters for
the script would use the 5:00am time and search for items in a 911
database where an event occurred in the past 24 hours by a designated
jursidiction. A report would then be generated.

Is there a way to schedule such a script AND (another kicker), email
the results?
 
A

aaron.kempf

SQL Server jobs can schedule jobs and scripts.. and email the results.

Without writing any code.

The answer is obvious-- if you're doing anything like 911 then you
should definitely use SQL Server.

-Aaron
 
Top