Post reply

Task Scheduling

  • May 27, 2008 at 6:23 am

    #186999

    Can any one tell me how to schedule the tasks in SQL Express both through wizard and usign T-SQL statements

    [font="Arial"]Nothing is impossible with Hard Work[/font]:)

  • June 2, 2008 at 1:36 pm

    #823256

    SQL 2005 Express edition does not provide built-in functions in SQL Agent to manage jobs as far as I know. However, we can use the third party tool to implement the management.

    Here is a link. May it help.

    http://www.valesoftware.com/onlinehelp/jobserver/index.htm

  • June 2, 2008 at 10:19 pm

    #823390

    Dear Friend,

    Thanks a lot for your information.

    I have one more clarification:

    Is the enterprise edition of SQL 2005 will support the task scheduling?

    Or which edition of SQL 2005 with which service pack will support this?

    [font="Arial"]Nothing is impossible with Hard Work[/font]:)

  • June 3, 2008 at 12:48 am

    #823429

    Yes, Enterprise endition of SQL Server 2005 supports task scheduling.

    Except Express edition, all other editions support this.

    Suresh

    Don't work hard, work smart.

  • June 3, 2008 at 12:57 am

    #823432

    Dear Suresh,

    Thanks a lot for your information.

    Ok I will try with the enterprise edition.

    But is there any other methods available to perform the same through script?

    [font="Arial"]Nothing is impossible with Hard Work[/font]:)

  • June 3, 2008 at 1:03 am

    #823433

    Try Windows Scheduled Task.

    Suresh

  • June 3, 2008 at 1:11 am

    #823435

    Dear Suresh,

    Thanks for your reply.

    I will try it.

    Best Regards,

    M. J. Jaya Chitra

    [font="Arial"]Nothing is impossible with Hard Work[/font]:)

Viewing 7 posts - 1 through 6 (of 6 total)

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