Does Group Policy Guardian (GPG) require the 'SQL Server Agent' to be running? (NETIQKB43099)

  • Document ID:7743099
  • Creation Date:02-Feb-2007
  • Modified Date:15-Mar-2013
    • Micro Focus Products:
      Change Guardian

Environment

NetIQ Group Policy Guardian 1.6
NetIQ Group Policy Guardian 2.0

Situation

Does Group Policy Guardian (GPG) require the 'SQL Server Agent' to be running?

Resolution

The core functionality of Group Policy Guardian (GPG) does not require the SQL Server Agent to be running. However, one of the functions of Group Policy Guardian is the ability to groom the database.  The grooming job runs as a job in SQL.  If the SQL Server Agent is not running, the GPG grooming job will not run.

To check the status of the Grooming job:

  1. Open Enterprise Manager and connect to the GPG Database.
  2. Expand the GPG Database machine node.
  3. Expand the Management node.
  4. Expand SQL Server Agent node.
  5. Select Jobs.
  6. Check the Last Run Status of grooming job.


Additional Information

Formerly known as NETIQKB43099