BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 03-20-2009, 09:59 AM   #1
prdaley
Knows Where the Search Button Is
 
Join Date: Mar 2009
Model: na
PIN: N/A
Carrier: na
Posts: 16
Default SQL jobs not running; I just took over server.

Please Login to Remove!

Hey all,

Oh joy! A BES server just landed in my lap. The Windows error logs were just getting jammed with stuff and I figured out relatively quickly that the following jobs under SQL Management were failing each time they ran.

RIMPurgeHistoryBESMgmt
RIMPurgeMDSMsgBESMgmt
RIMPurgeMDSStatsBESMgmt
RIMPurgeOTASLBESMgmt
RIMPurgeWorkQueueBESMgmt

The problem is the owner that they're set to run under no longer exists. It looks like someone set up this server with the default name created by Windows and then changed the name of the server at a later point in time, after the jobs were already created. I looked at the job history on all of these and none of them have ever run successfully. Some of them have been failing for nearly two years. I've been unable to change the owner of the jobs, although I'm sure I could just recreate all of them with current credentials.

My real fear is that if I get these jobs to run correctly they're going to have to purge two years worth of data, may not finish correctly, may crash the server, etc.

This server is due for a rebuild, but in the meantime does anyone have any thoughts? Ramifications for running or continuing to not run these jobs?
Offline  
Old 03-22-2009, 01:35 PM   #2
stuwhite
Feeling Blue, Bigly ;->
 
stuwhite's Avatar
 
Join Date: Jan 2007
Location: U to the K
Model: 9000
PIN: 3, it's the magic number
Carrier: Most of them, it's a Global Village man!
Posts: 1,273
Default

Welcome to the land of besadmin dude .

Is everything on the BES and BBs running fine? I am not on my machnies now but don't recall ever seeing those jobs. If you are running fine and planning a new/rebuilt box, I would tend to leave well alone. But do ensure you follow the knottyrope Mantra (TM) - backup backup backup!!! Your db is the heart of the BES so ensure you are getting at least one good backup a day before you go much further
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
Offline  
Old 03-24-2009, 02:57 AM   #3
noname
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Default

Try KB04293 - How to switch BlackBerry Enterprise Server service accounts

Source: View Document
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 03-24-2009, 03:00 PM   #4
prdaley
Knows Where the Search Button Is
 
Join Date: Mar 2009
Model: na
PIN: N/A
Carrier: na
Posts: 16
Default

Thanks for the replies. I'll check out KB04293 and report back if I start running the jobs. I'm still afraid to get these jobs running because I don't know what will happen if they've been failing for such a long time, but all of the sudden get turned on. You would think the purge they'd be running would be huge.

Yes, everything is working fine for the users.
Offline  
Closed Thread



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


ESI IMPEDANCE BRIDGE MODEL 250-DE picture

ESI IMPEDANCE BRIDGE MODEL 250-DE

$99.99



HP-Agilent-Keysight 41951-69001/ 41951-61001 Impedance Test Adapter for 41951A picture

HP-Agilent-Keysight 41951-69001/ 41951-61001 Impedance Test Adapter for 41951A

$500.00



Digital Ohmmeter LCD Audio Impedance Test Meter Speaker Voice Resistor System picture

Digital Ohmmeter LCD Audio Impedance Test Meter Speaker Voice Resistor System

$83.60



Tenma Audio Impedance Tester 72-6948 picture

Tenma Audio Impedance Tester 72-6948

$109.98



BAS-Zahner Amos IM6 Impedance measurement unit picture

BAS-Zahner Amos IM6 Impedance measurement unit

$499.99



BECO Universal Impedance Bridge Model 315A, Brown Electro Measurement Corp. 315A picture

BECO Universal Impedance Bridge Model 315A, Brown Electro Measurement Corp. 315A

$129.99







Copyright © 2004-2016 BlackBerryForums.com.
The names RIM © and BlackBerry © are registered Trademarks of BlackBerry Inc.