Skip to content
ProjectControls.com
Oracle Primavera - PM6

Primavera P6 Background Jobs

In the Open Standard
Emily FosterMember for 15 years 2 months
Created
6
6
0

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

Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Ronald Winter ·
    #1

    Emily, This is a very

    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?

    Report
  2. 0
    Dennis Hanks ·
    #2

    Ron/Emily:Should you develop

    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.

    Report
  3. 0
    Emily Foster ·
    #3

    Hi Ronald - Thanks for the

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

    Report
  4. 0
    Emily Foster ·
    #4

    Hi Dennis,You would need to

    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
    Report
  5. 0
    Dennis Hanks ·
    #5

    Thanks Emily, getting into

    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.

    Report
  6. 0
    Emily Foster ·
    #6

    I thought you may ne

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?