Schedule a SQL Statement
Last Post 02/18/2009 9:48 AM by Joseph Craig. 1 Replies.
Author Messages
MissingMoJo
Nuke Newbie
Nuke Newbie
Posts:2


--
02/18/2009 9:41 AM

    I have implemented the MAP module and an currently manually running a small sql statement that populates the map points with the information from an events module.  This part works great.

    I need to know how i can schedule this sql statement to run automatically say at 2am everyday.

    Thanks in advance.

    Joseph Craig
    DNN MVP
    Posts:11667


    --
    02/18/2009 9:48 AM
    A couple of suggestions:

    • From Mitchel Sellers: "If you have a version of SQL Server that is anything greater than Express you could schedule an SSIS package to run and perofrm the task."
    • Also from Mitchell Sellers:  A free module to schedule SQL tasks is available here.

    Joe Craig, Patapsco Research Group
    Complete DNN Support


    ---