How to use task scheduler to execute a SQL 2008 query?


  • I have a SQL 2008 express query that needs to be executed twice a day. When executed, the query produces a file with data. The query works fine as it is a cmdshell query. I just need to know how to set up a scheduled task (with windows scheduled task manager) to execute the query automatically. Like is there triggers or commands that I have to put in to make it open the database and run the query?

    Ron Sweatland
    Tuesday, May 10, 2011 10:51 PM


All replies