Post reply

Schedular in SQL

  • June 17, 2009 at 11:15 pm

    #138801

    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

  • June 18, 2009 at 12:15 am

    #1011443

    Try creating maintenance plan to execute your sp

    Tanx 😀

  • June 18, 2009 at 1:38 am

    #1011489

    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

  • June 18, 2009 at 2:17 am

    #1011512

    Hi,

    Thank you for the Reply. I am having SQL2005

  • June 18, 2009 at 2:49 am

    #1011525

    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