> For the complete documentation index, see [llms.txt](https://upsolver.gitbook.io/content/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://upsolver.gitbook.io/content/reference-1/monitoring/job-status/cdc-sources/job-settings.md). # Job Settings The **Job Settings** tab displays the SQL code used to create the job, alongside job options, and details:

The Job Settings tab shows the SQL code to create the job, along with job options, and details

## SQL View the full SQL code used to generate the job. This code includes all job and source options provided when you created the job, or the default options used by Upsolver. The code can be copied into a Worksheet if you want to re-use it. *** ## Options The job options provided when you created the job or the default options used by Upsolver - these will vary depending on your source database:

Job Option	Value
COMPUTE_CLUSTER	The name of the cluster that executes the job. Click on the link to view further details about the cluster.
HEARTBEAT_TABLE	The name of the heartbeat table for PostgreSQL sources.
INTERMEDIATE_STORAGE_CONNECTION	The name of the connection to stage the data ingested from the CDC source.
PUBLICATION_NAME	The publication name for PostgreSQL sources.
PARSE_JSON_COLUMNS	If true, Upsolver will parse JSON columns into a struct matching the JSON value.
SKIP_SNAPSHOTS	When true, Upsolver will not take an initial snapshot and only process change events starting from the time the ingestion job is created. Otherwise, a snapshot will be taken.
MERGE_PARTITIONED_TABLES	If true, Upsolver will merge the partitioned tables.
INTERMEDIATE_STORAGE_LOCATION	The name of the location to stage the data ingested from the CDC source.

## Details The following details about your job are displayed:

Detail	Value
Description	The optional comment provided when the job was created or updated.
Created At	The date and time when the job was initially created.
Last Modified At	The date and time when the job was last updated.
Created By	The username of the person in your organization who created the job.
Last Modified By	The username of the last person in your organization to update the job.
Id	The globally unique identifier for the job. This Id can be used when querying system.information_schema.jobs and the system.monitoring.jobs tables.

--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://upsolver.gitbook.io/content/reference-1/monitoring/job-status/cdc-sources/job-settings.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.