The procedure is used to take CPU statistics,backups,update statistics,shrink ,fragmentation etc.

These procedures i think created by DBAs but extensively used by developers.