Sqlserver Agent Not Running - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Sqlserver Agent Not Running

Author

Topic

pankaj.pareek@sparrowi.co
Starting Member

26 Posts

Posted - 2007-08-30 : 05:20:28

Hello,

I am trying to copy offline data to online server by using DTS Scheduling.

My Sqlserver Agent not running, if i stopped sql server services and then start sql agent services then agent is working. I am starting again SQL Server Services then 'Sql-Server-Agent' automatically stoped.

please guide me.

Thanks & Regards
Pankaj Pareek

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-30 : 22:04:27

Sql agent service depends on sql server service, you can't startsql agent while sql serverservice is down.

pankaj.pareek@sparrowi.co
Starting Member

26 Posts

Posted - 2007-08-31 : 01:13:30

quote:
Originally posted by rmiao

Sql agent service depends on sql server service, you can't startsql agent while sql serverservice is down.

Hi,

My problem is sqlserver Agent not running with sql-server services.
if i stoped sqlserve services by using sql services manager and start the sqlserver Agent services, services manager display running.

Thanks
Pankaj Pareek

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-31 : 16:19:26

You mean start sql server service first then start sql agent service? That's correct order, so what's the problem? Did you get any error when try to start sql agent service?

pankaj.pareek@sparrowi.co
Starting Member

26 Posts

Posted - 2007-09-01 : 03:23:15

quote:
Originally posted by rmiao

You mean start sql server service first then start sql agent service? That's correct order, so what's the problem? Did you get any error when try to start sql agent service?

Hi,

First Start the Sqlserver Services. its running ok.
Second Start the Sqlserver Agent Services. its not running no error message display.

thats my problem.

pls help me.

Regards
Pankaj Pareek

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-01 : 18:57:36

Did you check windows app event log? Should have message there.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources