Environment
AppManager 7.0.x
Situation
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
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.