How do I manually recreate the AppManager Repository SQL jobs? (NETIQKB45072)

  • 7745072
  • 02-Feb-2007
  • 16-Feb-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

How do I manually recreate the AppManager Repository SQL jobs?

Resolution

Instructions to recreate the Repository SQL scheduled jobs:

  1. On the SQL server where the repository is stored, open SQL Query Analyzer.
  2. Point the DB field to the AppManager Repository Database (QDB by default).
  3. Type in the following statement:

    To recreate the NetIQ License Audit and NetIQ AMDC Daily SQL jobs:

    exec dbo.task_utilext 1,1

    To recreate all other NetIQ AppManager SQL jobs:

    exec dbo.task_util 1,1,1

  4. Click on the green (execute) arrow.

Go back into SQL Management Studio/Enterprise Manager and verify all nine NetIQ tasks have been recreated.  The NetIQ Policy QDB job should now show up in the SQL scheduled job list.

Additional Information

Formerly known as NETIQKB45072