Run report from script and email

  • Thread starter Thread starter Annette
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MPV - versitile fast lean player. 3
task scheduler 17
Using Scheduled Tasks to run Macros problem 2
Reports - Passing Parameters to Source Query 2
problem with windows scheduler running msaccess database processin 2
Windows 8 (cross-post from w2k forum) Running .bat files minimized from scheduler - in windows 8 (x64) ?? 0
Can I schedule a macro to run automatically at a certain time? 1
Outlook "Run a script" dialog box empty (Outlook 2016) 0

Back
Top