Is there an API method equivalent to manually clicking 'Compile' on an invalid database object, so recompiling all currently-invalid packages/objects can be scheduled as a recurring database task instead of done by hand?

All FAQ questions / Developer Studio, deployment, and upgrades

Answer

Yes — Database_SYS.Compile_All_Invalid_Objects recompiles every currently invalid object, the same effect as clicking Compile individually for each one. Wrapping a call to this in a Scheduled Database Task gives you a periodic, automated recompile of invalid objects instead of needing to do it manually.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Developer Studio, deployment, and upgrades questions