BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 03-20-2009, 10:59 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2009
Model: na
PIN: N/A
Carrier: na
Posts: 16
Post Thanks: 0
Thanked 0 Times in 0 Posts
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, 02:35 PM   #2 (permalink)
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
Post Thanks: 0
Thanked 0 Times in 0 Posts
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, 03:57 AM   #3 (permalink)
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
Post Thanks: 6
Thanked 9 Times in 9 Posts
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, 04:00 PM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2009
Model: na
PIN: N/A
Carrier: na
Posts: 16
Post Thanks: 0
Thanked 0 Times in 0 Posts
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


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-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.