> For the complete documentation index, see [llms.txt](https://docs.collibra.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.collibra.com/data-quality-self-hosted/core-concepts/reports/missing-jobs-report.md).
# Missing Jobs Report
## What is a Missing Jobs Report?
The Missing Jobs report provides a view of Collibra DQ jobs that were expected but didn't run on schedule.
You can generate a Missing Jobs report from the Reports page.
## Steps
{% stepper %}
{% step %}
Sign in to the Collibra DQ instance and click the 
Reports icon in the left navigation pane.\ :chevrons-right: The Reports page opens.
{% endstep %}
{% step %}
From the Reports page, select the **Missing Jobs Report** link.
{% endstep %}
{% step %}
To configure the type of chart configuration and data you want to see in the chart, click the ellipsis icon.
{% endstep %}
{% step %}
Click 
**Chart Configuration**.The Chart Configuration window displays.
{% hint style="info" %}
As a best practice, keep the Chart Configuration as the default.
{% endhint %}
{% endstep %}
{% step %}
For x-axis, select one of the following options from the X-Axis Column dropdown list:
* **count**
* **updt\_ts**
{% endstep %}
{% step %}
For y-axis, select one or more of the following options from the Y-Axis Columns dropdown list:
* **count**
* **updt\_ts**
{% endstep %}
{% step %}
For the type of chart you want to display, select one of the following options from the Chart Type dropdown list:
* **Line**
* **Area**
* **Column**
* **Scatter**
{% endstep %}
{% step %}
Click **Save**.
{% endstep %}
{% step %}
Navigate the pages of your report by clicking the **Previous** and **Next** pagination buttons, located bottom-right of the columns.
{% endstep %}
{% endstepper %}
## Sample SQL query
You can use the following sample SQL query for a Missing Jobs report.
```
SELECT jsa.updt_ts::date AS updt_ts,
jsa.dataset,
bus.name AS business_unit,
js.freq,
js.active,
js.mon,
js.tue,
js.wed,
js.thu,
js.fri,
js.sat,
js.sun
FROM job_schedule_attempt jsa
JOIN job_schedule js ON js.dataset::text = jsa.dataset::text
LEFT JOIN dataset_scan ds ON ds.dataset::text = jsa.dataset::text AND ds.updt_ts::date = jsa.updt_ts::date
LEFT JOIN business_unit_to_dataset bu ON jsa.dataset::text = bu.dataset::text
LEFT JOIN business_units bus ON bus.id = bu.id
WHERE ds.updt_ts IS NULL AND jsa.updt_ts >= (now() - '20 days'::interval)
ORDER BY (jsa.updt_ts::date) DESC
```