Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Primavera P6 Background Jobs

6 replies [Last post]
Wed, 2013-05-01 14:15
Emily Foster
User offline. Last seen 1 year 46 weeks ago. Offline
Joined: 19 Aug 2011
Posts: 625
Groups: None

Here's an in-depth article on tuning the Primavera P6 Background Jobs http://ow.ly/kBkHC

Top

Replies

Thu, 2013-05-09 13:18
#1
Emily Foster
User offline. Last seen 1 year 46 weeks ago. Offline
Joined: 19 Aug 2011
Posts: 625
Groups: None

I thought you may ne interested to know that we've just posted Part 2 on tuning the Primavera P6 Background Jobs http://ow.ly/kRlSX

Top
Mon, 2013-05-06 16:04
#2
Dennis Hanks
User offline. Last seen 8 years 1 week ago. Offline
Joined: 17 Apr 2007
Posts: 310
Groups: Petro-Chem / Oil & Gas

Thanks Emily, getting into SQL Server Mgt. Studio 2012 is no problem, but I still have no idea how to execute your command  "SELECT count(*) FROM REFRDEL" or any of the other suggestions.  Not a big deal, but it might be nice to know.  Will try to find a way to execute background jobs during normal working hours - maybe lunch.  Keep the tips coming, it is a great service.

Top
Mon, 2013-05-06 15:51
#3
Emily Foster
User offline. Last seen 1 year 46 weeks ago. Offline
Joined: 19 Aug 2011
Posts: 625
Groups: None

Hi Dennis,

You would need to start your version of SQL Server Management Studio (SSMS).  I use the express version of SQL Server 2005 so mine is actually called "SQL Server Management Studio Express".  You may have a different name if it is 2008 or some other version. I found my by going to "Start > All Programs > Microsoft SQL Server 2005" and it was in that folder. This is the application from where you do just about anything with a SQL Server database. There are plenty of tutorials and books that can help you get familiar with this. I hope this helps even a little. Emily
Top
Fri, 2013-05-03 14:07
#4
Emily Foster
User offline. Last seen 1 year 46 weeks ago. Offline
Joined: 19 Aug 2011
Posts: 625
Groups: None

Hi Ronald - Thanks for the positive feedback and a great question. The code is Oracle specific but the principles are not.

Top
Thu, 2013-05-02 14:56
#5
Dennis Hanks
User offline. Last seen 8 years 1 week ago. Offline
Joined: 17 Apr 2007
Posts: 310
Groups: Petro-Chem / Oil & Gas

Ron/Emily:

Should you develop a 'cook book' approach to cleaning SQL servers, I would be most interested.  I am pretty sure that I do not have any where near the problem cited, but I am also sure that my 'background agent' has never run - computer usually shutdown evenings and weekends.

By 'cook book', I mean elementary database commands.  I can access SQL Server Management Server, but have almost no clue as to how to get into P6 databases.  BTW: I have 7 P6 databases, most small.

For instance: I have no idea how to execute your command   SELECT count(*) FROM REFRDEL

Any help appreciated, thanks.

Top
Wed, 2013-05-01 14:47
#6
Ronald Winter
User offline. Last seen 3 years 5 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None

Emily,

 This is a very interesting article.  It did not say if this applied to both MS SQL as well as Oracle databases.  Is the article database-type specific?

Top