SQL 2005 Express - problem with no "SQL Serevr Agent"

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jc
    #1

    SQL 2005 Express - problem with no "SQL Serevr Agent"

    Hello.
    I have loaded SQL 2005 Express (from the web) with SQL Server
    Management Studio Express. I suspect this means that the "SQL Server
    Agent" is not available. This "SQL Server Agent" comes with SQL 2000
    (even the free version of MSDE 2000 has this feature). This agent is
    useful for scheduling jobs (in conjunction with the available
    Enterprise Manager).

    So my problem is how do I schedule jobs with this product? It is
    running on the XP OS.

    Regards JC.......
    Tags: None
    • Erland Sommarskog
      #2
      Re: SQL 2005 Express - problem with no "SQL Serevr Agent"

      jc (jim.clifford@g m.com) writes:
      I have loaded SQL 2005 Express (from the web) with SQL Server
      Management Studio Express. I suspect this means that the "SQL Server
      Agent" is not available. This "SQL Server Agent" comes with SQL 2000
      (even the free version of MSDE 2000 has this feature). This agent is
      useful for scheduling jobs (in conjunction with the available
      Enterprise Manager).
      >
      So my problem is how do I schedule jobs with this product? It is
      running on the XP OS.
      You could use the Task Scheduler which is built into Windows.



      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        Previous template Next
        Working...