Schedular in SQL

  • Hi All,

    Can anyone tell me how to implement schedular in SQL so that the Schedular will execute a Query or SP everyday or everyweek on certain time.

    Thank You All

  • Try creating maintenance plan to execute your sp

    Tanx 😀

  • Hello,

    I suspect it is a SQL Server Agent Job that you need.

    Please see the SQL Server Books Online Topic “Implementing Jobs”.

    BTW - Which edition of SQL Server do you have?

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • Hi,

    Thank you for the Reply. I am having SQL2005

  • Hello again,

    I asked because the SQL Server Agent is not included in the Express edition of SQL Server 2005. I hope you have one of the other Editions.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply