Primavera P6 Background Jobs

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

Oracle Primavera - PM6
D
Dennis Hanks 👤 Member for 19 years 1 month
· Permalink

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.

E
Emily Foster 👤 Member for 14 years 9 months
· Permalink

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
E
Emily Foster 👤 Member for 14 years 9 months
· Permalink

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

D
Dennis Hanks 👤 Member for 19 years 1 month
· Permalink

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.

R
Ronald Winter 👤 Member for 23 years 5 months
· Permalink

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?

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts