Jobs

See what each job does on each database, act on a job that is stuck or fails, and set the schedule of each job.

Settings, Jobs with the databases on the left and ERPPRD on the right, where SQL Stat Snapshot is stuck for 38 min
Jobs opens on the database in the worst trouble.

Before you begin

You need Manage Settings. The page refreshes every five seconds.

Find a job that needs you

  1. Open Settings › Jobs.

  2. Under Needs you, click a database. Active and All show more databases.

  3. On the right, read the jobs under Needs you. Each row gives the state and the reason.

Run or restart a job

Click the icon at the end of the job row. Point to it first to see what it does.

JobWhat the icon does
A job with its own thread on each databaseRestarts the job on this database only. It starts again within a minute.
A stuck jobRestarts the job on every database, after you confirm. Scops drops the work that is stuck.
Any other jobRuns the job on this database now.

Change the schedule of a job

Job Settings with the cards Every few minutes, At a set time and System jobs, and for each job its switch, its schedule, At once and its last run
  1. Click Job Settings at the top right.

  2. Change On, Runs every, Runs at or At once.

  3. Click Save.

A change applies from the next run. Runs every is 1 to 1,440 minutes, and At once is 1 to 500 databases at the same time. A system job is always on: only its At once can change.

What you see

StateMeaning
StuckA call did not return within the time limit of the job.
Failed n times, FailingThe last runs on this database failed.
RunningThe job works on the database now.
WaitingThe job waits for a free thread, or a free place in its At once.
IdleThe job is on time.
Switched off, Not set upThe job is off, or it does not work on this database.

A red slot in the thread blocks is a stuck call. If a database is still busy at the next run, the job skips it. The other databases do not wait.

Every job

JobDefault scheduleAt onceWhat it does
Every few minutes
Alert Monitor5 min50Checks the alert rules.
Check Database5 min50Checks that each database answers.
OS Log Collector5 min20Reads the OS logs over SSH.
Reports10 min20Runs the scheduled reports.
At a set time
Repo CollectorDaily 03:0020Inventory, sizes, license use, services.
Schema CatalogDaily 04:0020The objects for the Objects page.
Weekly Perf ReportMonday 10:0020The weekly performance report.
System jobs
5-Min Summary Cache5 min505-minute and hourly activity in memory.
Archiving1 min256Copies old rows to the archive database.
Change Event Collector10 min20Plan changes. Statistics gathers, parameter changes and DDL every 30 min.
Compression1 min256Runs Compression after you start it.
Databases Cache5 min20The totals for all databases.
HealthCheck Cache10 min50The Health Check data.
Hourly Data Collector1 hour2030 days of history for Ask Scops.
Insights SqlStat Cache10 min20The heaviest statements for Insights.
Page Cache1 hour20The Overview, Services and Objects pages.
Pool Occupancy5 min20How full each connection pool is.
Radar5 min20Runs Radar Engine.
Recompress Analysis4 hours20Tables to compress again.
Repo Perf Collect1 minEach its ownMetrics and space history.
Repo Rollup1 min205-minute and hourly totals, and removal of old data.
Repository Audit5 min20The seals of the Audit Trail.
Self-Heal1 hour20Keeps the repository healthy.
Session Sampler30 sEach its ownThe active sessions.
Sizing Cache1 hour20The last-week view of Sizing.
SQL Stat Snapshot10 minEach its ownThe statistics of each SQL statement.
Statistics1 min256Gathers stale and missing statistics.
Summary Cache5 min20The Summary page.
System Health1 min20Checks the repository. See Health.
Unified Cache Refresh15 s50The live data of the Dashboard and Metrics.

Each its own: the job has its own thread on each database.

Updated November 9, 2026