List Jobs modified in the last N hours


This SQL query lists any Jobs which have been started, stopped or modified in the last N hours. The age may be changed by adjusting the value of th @HOURSAGO variable. The query should be executed in SQL Server Management Studio against the AppManager Repository, not Control Center database.

Note that Deleted Jobs will be highlighted only until they are permanently cleared from the database by the Daily (SQL) Job which runs overnight.


Alain Salesse
Systems Management Consultant, NetIQ
44 7827 342476


NetIQ does not test or validate any software, code or other materials provided in, on or through NetIQ Cool Solutions (collectively, "Materials"), so please use caution when downloading or accessing any Materials from Cool Solutions and ensure that you have reasonable and current security, spyware and anti-virus measures in place on your computer and/or network prior to downloading. Additionally, do not use any Materials downloaded from Cool Solutions in any production environment without first testing the Materials to ensure they are compatible with your version of NetIQ software or any other hardware or software present in your network or environment. Cool Solutions is not a substitute for authorized NetIQ support and should not be used as such. NETIQ COOL SOLUTIONS AND ANY MATERIALS ARE PROVIDED ON AN AS-IS, AS-AVAILABLE BASIS WITHOUT ANY WARRANTY OF ANY KIND. By downloading this file, you are agreeing to these terms of use. To report a problem please contact: Your use of Cool Solutions is governed by the Cool Solutions Terms and Conditions.


How To-Best Practice
Comment List