
In the continuing journey to track down impacted objects and to determine when the code in a database was last changed or added, here is another quick SQL, which can be used in Aginity Workbench for Netezza to retrieve a list of when Store Procedures were last updated or were created.
SQL List of When A Stored Procedure was Last Changed or Created
select t.database — Database
, t.OWNER — Object Owner
, t.PROCEDURE — Procedure Name
, o.objmodified — The Last Modified Datetime
, o.objcreated — Created Datetimefrom _V_OBJECT o
, _v_procedure t
where
o.objid = t.objid
and t.DATABASE = ‘<<Database Name>>‘
order by o.objmodified Desc, o.objcreated Desc;
Related References
- Netezza / PureData – How To Get a SQL List of When View Was Last Changed or Created
- Netezza / PureData – Dictionary Views
- PureData / Netezza – Useful links
One thought on “Netezza / PureData – How To Get A List Of When A Store Procedure Was Last Changed Or Created”
Comments are closed.