Re: How can I add the SQL Server Agent??

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: BJ (lmelogra_at_optonline.net)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 03:36:44 -0500

I am trying to run the BACKUP feature from the Enterprise manager on a
database. It said something about having a SQL agent running. I don't see
any sql agent in the services list :(

"Steve Thompson" <stevethompson@nomail.please> wrote in message
news:utGvXFA9EHA.3504@TK2MSFTNGP12.phx.gbl...
> Could you explain what you need this option for? It doesn't sound like you
> are talking about the SQL Server Agent.
>
> Steve
> "BJ" <lmelogra@optonline.net> wrote in message
> news:%23qZno7o8EHA.3828@TK2MSFTNGP09.phx.gbl...
>> no go..When it was installed there was an option for Server Agent or
> Remote
>> Server Agent..I forget which...but that's the part I need..
>>
>>
>> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote
>> in
>> message news:eOwDfPo8EHA.2600@TK2MSFTNGP09.phx.gbl...
>> >> I installed SQL Server 2000 on a server and realized I need the Server
>> > Agent
>> >> in order to do the database backups from Enterprise Manager. I looked
> at
>> >> the install CD and am lost. Any help would be appreciated!
>> >
>> > SQL Agent is installed with SQL Server; I guess you need just to start
> it.
>> > Check the "Starting SQLServerAgent Service" topic in Books OnLine.
>> >
>> > --
>> > Dejan Sarka, SQL Server MVP
>> > Associate Mentor
>> > www.SolidQualityLearning.com
>> >
>> >
>>
>>
>
>

Relevant Pages

  • RE: Biztalk 2004 Spool table zombies
    ... You should always have SQL Agent running ... asked you to install and what "db changes" that entailed. ... Also could you please pass on the scripts to validate message box ...
    (microsoft.public.biztalk.general)
  • Re: Maintenance - Integrity Check failure
    ... > most likely the default database for the SQL Agent service ... >>>command for checking the integrity check of a database ... The command line integrity ...
    (microsoft.public.sqlserver.server)
  • Re: Maintenance - Integrity Check failure
    ... If you get this when SQL Agent logs in to run a job then ... most likely the default database for the SQL Agent service ... account is assigned to a database that no longer exists on ...
    (microsoft.public.sqlserver.server)
  • Re: automatisiert Tabellenstruktur auslesen
    ... Jobs kannst Du mit dem SQL Agent erstellen ... Emails kannst Du mittels Database Mail versenden ...
    (microsoft.public.de.sqlserver)
  • RE: where are my dts packages
    ... The other thing to note is that the schdules for the sql Agent is also stored ... your user information and database connected to this instance ... Whenever you create a new DTS package it will be stored in ... MSDB database sysdtspackages system table. ...
    (microsoft.public.sqlserver.dts)