How do I automate a nightly sql script to output results to a user?
Posted on 2006-10-24
hi all, anyone have an idea on how to send output from a sql statement to a user on a regular basis? i have a statement (select * from blah where blah) that gives results that are needed by a user on our floor. This user does not have access to run the query, but she needs the output daily, and management wants the job run automatically, similar to a nightly batch job to run at 11:59 pm to give results for day.
we are amidst development of an actual report that shows this information, so this is only going to be a temporary solution.
any suggestions would be greatly appreciated. i could probably write the sql as a stored procedure, then have a web page display the results, but that seems like overkill for this task.