Script to remove an old JobScheduler instance from the inventory tables

Current Situation

When uninstalling a JobScheduler Master the records in the inventory tables still remains in the database

Desired Behaviour

There should be a sript that removes all records for a specific JobScheduler Instance.

The instance will be identified by the scheduler_id, hostname and port

The script will read the instance_id for this instance from the table SCHEDULER_INSTANCES and will delete all records in the tables

• INVENTORY_INSTANCES
• INVENTORY_AGENT_CLUSTERS
• INVENTORY_AGENT_CLUSTERMEMBERS
• INVENTORY_AGENT_INSTANCES
• INVENTORY_FILES
• INVENTORY_JOB_CHAIN_NODES
• INVENTORY_JOB_CHAINS
• INVENTORY_JOBS
• INVENTORY_LOCKS
• INVENTORY_ORDERS
• INVENTORY_PROCESS_CLASSES
• INVENTORY_SCHEDULES

The script should be called by the JobScheduler uninstaller.