Red Gate forums :: View topic - SQL agent not running
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

SQL agent not running

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Andrew Hodge



Joined: 19 Jul 2007
Posts: 90
Location: Kent, UK

PostPosted: Fri Mar 26, 2010 8:59 am    Post subject: SQL agent not running Reply with quote

Hi,

I get a an instance of SQL Agent not running per night across a number of servers. These are related to when the server is

1) Either getting hit by a job
or
2) When a snapshot is occuring of the virtual machine disks and the i/o to the disks is frozen for a very short period (less than 3 seconds).

What is this warning actually monitoring? Is it checking the service status?

I dont get any errors about sql server or computer unreachable just the SQL Agent not running.

Are there any behind the scenes configuration options for this one?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 889
Location: Red Gate Software

PostPosted: Mon Mar 29, 2010 4:04 pm    Post subject: Reply with quote

Thank you for your post into the forum.

The SQL Server Agent not running alert is generated when either the SQL Server Agent service is in a stopped state or encountered a problem which has caused it to fail.

The SQL Server Agent not running alert (along with the Job Failure, Job did not start and Job Duration unusual alerts) is checked every 60 seconds.

The computer unreachable and SQL Server unreachable alerts are checked every 5 mins, which may explain why you do not experience these particular alerts

A support call has been created for you, the support call reference is F0033005. Can you please sent to us a copy of the Alert Repository Log File you us to analyze via e-mail to support@red-gate.com with the call reference number in the subject field of the e-mail.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Andrew Hodge



Joined: 19 Jul 2007
Posts: 90
Location: Kent, UK

PostPosted: Tue Mar 30, 2010 12:07 pm    Post subject: Reply with quote

Sent log through to support
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group