Posted on: 11/3/2011 5:45:10 PM | Views : 220


Hi,
 
I would like to know how schedule task which automaticly run SQL query saved in file "Report.sql". To be more concrete.
I have query "Report.sql" saved in folder C:\Reports\Report.sql. This is just SELECT statement and statement which saves result to file.  I want to schedule task which run this file every day at 2:00AM. I know that Express version of MS SQL Server doesn't have a Agent. Is there any posibility to run it for example through Windows Task Scheduler and SQLCMD? Or any other way which will work, will be extremly helpful.
Thank you for your answers

...

Go to the complete details ...