BlackBerryForums.com : Your Number One BlackBerry Community      

»Sponsored Links




Closed Thread
 
LinkBack Thread Tools
  (#1 (permalink)) Old
autsoldnow Offline
Thumbs Must Hurt
 
Posts: 131
Join Date: Feb 2006
Location: Canada
Model: 7250
Carrier: Telus
Default SQL Server Agent - 04-28-2006, 02:49 PM

Does this need to be running?? We use MS SQL 2000 SP4.

Thanks
Andrew
   
Sponsored Links
Please Login or Register to Remove these Advertisements!

  (#2 (permalink)) Old
RemyJ Offline
Talking BlackBerry Encyclopedia
 
Posts: 469
Join Date: May 2005
Location: Denver, CO US
Model: 8830
Carrier: Sprint
Default 04-28-2006, 02:50 PM

It really needs to be running only if you have jobs scheduled, like database backups.
   
  (#3 (permalink)) Old
autsoldnow Offline
Thumbs Must Hurt
 
Posts: 131
Join Date: Feb 2006
Location: Canada
Model: 7250
Carrier: Telus
Default 04-28-2006, 02:54 PM

Quote:
Originally Posted by RemyJ
It really needs to be running only if you have jobs scheduled, like database backups.
Okay I am asking because we keep getting the following messages in our application log:

Source: SQLSERVERAGENT
Event ID: 318
Description:
Unable to read local eventlog (reason: The event log file has changed between read operations).

Source: SQLSERVERAGENT
Event ID: 311
Description:
Attempting to to re-open the local eventlog...

Source: SQLSERVERAGENT
Event ID: 312
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been missed.

Thanks
Andrew
   
  (#4 (permalink)) Old
noname Offline
CrackBerry Addict
 
noname's Avatar
 
Posts: 780
Join Date: Sep 2005
Location: Islet of Foreign Talents.
Model: 8100
PIN: FFFFFFFF
Carrier:
Default 04-28-2006, 06:40 PM

Is the "Event Log" Windows service running? What is it Log On as? Check to make sure the logon has administrative access if not using Local System Account...


noname
Nobody's stupid, some are just smarter...
[ http://www.blackberry.com/btsc/ ]
   
  (#5 (permalink)) Old
FlemmingRiis Offline
Thumbs Must Hurt
 
Posts: 102
Join Date: Mar 2005
Location: Denmark
Model: 7230
Carrier: TDC
Default 04-30-2006, 09:29 AM

Quote:
Originally Posted by autsoldnow
Okay I am asking because we keep getting the following messages in our application log:

Source: SQLSERVERAGENT
Event ID: 318
Description:
Unable to read local eventlog (reason: The event log file has changed between read operations).

Source: SQLSERVERAGENT
Event ID: 311
Description:
Attempting to to re-open the local eventlog...

Source: SQLSERVERAGENT
Event ID: 312
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been missed.

Thanks
Andrew

This is due to the windows event log being cleared. not a error in that sake just a comment from sql agent
   
  (#6 (permalink)) Old
idontknow Offline
Thumbs Must Hurt
 
Posts: 74
Join Date: Aug 2005
Model: 6230
Default 04-30-2006, 05:26 PM

Quote:
Originally Posted by autsoldnow
Does this need to be running?? We use MS SQL 2000 SP4.

Thanks
Andrew
YES!!! BESMgmt (or whatever you named your config db) has jobs installed to maintain it. They run every Sunday. Without this service running you are imdeing the SQL db from being properly maintained, which can lead to performance issues. Search the BB knowledge center for Database Maintanence for more info.
   
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On






Copyright © 2004-2008 BlackBerryNews.com, BlackBerryFAQ.com, BlackBerryForums.com.
The names RIM © and BlackBerry © are registered Trademarks of Research In Motion Limited.
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.0.1