Catapult SQL Job Control

Catapult SQL Job Controller v1.0.5 Installer 

What Is SQL Job Control?

SQL Job Control gives you direct visibility and control over the SQL Server maintenance jobs running on your Thunder server — index rebuilds, database snapshots, data cleanups, and more. These jobs are scheduled to run overnight, but if coaching staff are working late, they can cause Thunder to slow down at exactly the wrong moment.  

Installation

Run the installer (Catapult Sql Job Control Installer 1.0.5.exe, ~7 MB) and choose an installation type:

• Client (UI only) – Install on any workstation to manage jobs remotely. Most common for video coordinators.
• Server (UI + Service) – Install on the Thunder SQL Server machine. Required for automated scheduling.

Figure 1 – Choose Client for a remote workstation, or Server if installing directly on the SQL machine

Connect, Filter, and Read the Dashboard

Click Settings and enter your Thunder server IP and port (typically 8085). Add keywords like Thunder, XOS, or Day to filter the job list to only what matters for Thunder.

Figure 2 – Server Settings: IP, port, and keyword filters

The dashboard shows every matching job, its enabled state, next scheduled run, last run time, and last outcome. Green rows = enabled and last succeeded. Red = last run failed. Unchecked = currently disabled.

Figure 3 – Dashboard overview. Key Thunder jobs to watch: Snapshot Job day 1–7, XOS_Thunder_Nightly_SQL_Job, XOS_Thunder_AMS_SQL_Job.

Scheduling a Maintenance Window

The Job Scheduler is the safest way to protect your coaches. It disables selected jobs at a set time and automatically re-enables them after a defined number of days.

Figure 4 – Job Scheduler: select jobs, set disable time, and set duration for auto-re-enable

1. Click the Scheduler button in the dashboard.
2. Select the jobs to disable from the Job Name dropdown.
3. Set Time to when the disable should take effect.
4. Set Duration (days) — jobs will auto-re-enable after this many days.
5. Click Add Schedule, then Refresh Schedules to confirm.

Manual Control & Audit Trail

Immediate toggle: Check or uncheck the Enabled checkbox directly in a dashboard row, then click Refresh Jobs to confirm.

Audit trail: Every action is logged in Windows Event Viewer under Applications and Services Logs › XOS, recording the job name, action (enable/disable), triggering user/IP, and timestamp.

Quick Tips

• Plan ahead for tournaments – create a disable schedule 24–48 hours before the event. Set the duration to cover the trip plus a recovery day.
• Prefer the Scheduler over manual toggling – auto re-enable means maintenance never gets permanently skipped.
• Red ≠ disabled – a red Last Outcome means the job failed on its last run, which may need investigation regardless of enabled state.
• After a server reboot, confirm the Catapult SQL Job Control Service is Running before relying on schedules.