Index of Samples

The following sample queries demonstrate how to retrieve various pieces of information from the adTempus database.

Database Model

Download the adTempus 4 database model. This document provides an overview of the adTempus database model for users who wish to query the database directly.

Due to the complexity of the database model, getting information out of the database into a useful format can be difficult. Consider these alternatives to direct database queries:

• The adTempus API provides complete programmatic access to all adTempus data.
• For reporting, consider the Report Designer included in the adTempus Console, which allows for custom reports built on top of the API.

Warning

Direct updates to the adTempus database are not supported except at the direction of a support engineer, and may result in data corruption or unpredictable results. If you need to make programmatic updates to adTempus, use the API.

Sample Queries

Name	Description	Languages
Grant SQL Server database access to adTempus server	Grants access to the adTempus database for the machine where adTempus is running, allowing adTempus to connect to the database while running under the Local System account	SQL
List all jobs and steps	Lists all jobs and steps, including the full group name for each job	SQL
List email notification recipients for Jobs	Lists the names and addresses of all Notification Recipients used by Notification Actions and Notification Tasks in jobs	SQL
List jobs using a history retention setting other than the default	Lists all jobs that use a history retention setting other than the instance default	SQL