How do I get a report on Job History in AppManager? (NETIQKB54379)

  • 7754379
  • 02-Feb-2007
  • 08-Oct-2010

Environment

AppManager 6.x
AppManager 7.0.x

Situation

How do I get a report on Job History in AppManager?
How do I determine who updated, started, or stopped a job in AppManager?

Resolution

Run the following Microsoft SQL Server statement in SQL Query Analyzer against the AppManager repository to return all rows stored in the JobHistory table in the repository:

select  JobID,
 KSName,
 Operation,
 DateADD(second,LogTime,'1/1/1970 0:0:0') as Time,
 suser_sname(UserID)  as UserName
   from JobHistory
   Order by
 JobID,
 Time asc

Results from this query will be returned in the SQL Query Analyzer and used for informational purposes only.




Additional Information

Formerly known as NETIQKB54379

To gather details regarding job history, job auditing must be enabled in AppManager.  For information about how to enable job auditing, see the AppManager documentation or Help in the Operator Console.

Monitoring Policies will appear as the Sql Server Agent account. Since this is an automated process auditing will not show changes to a monitoring policy by an individual user.