Post reply

SQL Server Agent on SQL 2008 express edition

  • July 19, 2010 at 1:31 pm

    #221367

    I installed it on Windows 7 professional edition.

    I could see the service was running, but I could not use it. It is not shown in the SSMS. What is wrong?

    Many thanks for any input in advance.

  • July 19, 2010 at 1:38 pm

    #1195113

    SQL Server Agent is not available in SQL Server Express.

  • July 19, 2010 at 1:48 pm

    #1195122

    But...you can be sneaky and use windows schedules tasks to get around that "limitation" if you really need to use Express edition.

    The Redneck DBA

  • July 19, 2010 at 2:56 pm

    #1195151

    What I do not understand is why we cannot use SQL Agent in SQL 2008 express edition since the service is running.

    Does it make sense?

  • July 19, 2010 at 5:05 pm

    #1195224

    I am not sure why service is running and agent is not available in express edition. It’s on top of my head to answer ;-). But I have utilized the windows scheduler to schedule a SQL job.For more information use the following link.

    http://support.microsoft.com/kb/2019698

    Rgrds

    Hema.,

    Regards
    Hema.,

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

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