what we have to do when sql server agent was down

Question

Post reply

what we have to do when sql server agent was down

AAKR

SSCommitted

Points: 1586
More actions
August 8, 2011 at 2:03 pm

#242733

how to get it out
thankyou in advance

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

is the service stopped?

Are you getting errors?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

AAKR SSCommitted Points: 1586 More actions · Answer 2

AAKR

SSCommitted

Points: 1586

August 8, 2011 at 2:18 pm

#1365516

error...

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

What is the error?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 4

Have you tried to start the service? You can do that through the Management Studio interface or by opening the SQL Server Configuration Manager. You can even use netstart commands for the service. If these don't work, do they generate an error? If so, what's the error?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

BuntyBoy SSCommitted Points: 1876 More actions · Answer 5

Do you want to get notified when SQL Server agent goes down?

or

You want to know the steps/action to perform in order to restart this service?

===========================================
Better try and fail than not to try at all...

Database Best Practices[/url]

SQL Server Best Practices[/url]

Knowledge Hunter SSCrazy Points: 2287 More actions · Answer 6

Open SQL Server Configuration manager

Right click and start the SQL Server Agent.

If the SQL Service is stopped it will automatically kick start the service.

If you get issue with logins open SQL Server Agent Properties -> and check the credentials.

Start the service.

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 7

Look up

http://msdn.microsoft.com/en-us/library/ms180965.aspx

Jayanth Kurup[/url]