# Edit job properties

Job properties control how a job behaves and how it logs what it is doing. 

To configure job properties, complete the following steps:

1. Log into the Pentaho User Console.
2. Open **Pipeline Designer**: 

   * If you are using the **Modern Design**, in the menu on the left side of the page, click **Pipeline Designer**. 
   * If you are using the **Classic Design**, click **Switch to the Modern Design,** and then in the menu on the left side of the page, click **Pipeline Designer**. 

   **Pipeline Designer** opens with the **Quick Access** section expanded.
3. In the table at the bottom of the screen, select either the **Recently opened** or **Favorites** tab.
4. Open the job: 
   1. Search for or browse to the job, and then click **Open**.
   2. Click **Open files**, and then in the **Select File or Directory** dialog box, search for or browse to the job and click **Open**.
5. In the **Canvas Action** toolbar, click the **Settings** icon. The **Job Properties** window opens.
6. Configure the properties in each tab. To learn more about the properties in each tab, see the [Job properties](#job-properties) in this topic.
7. To generate the SQL code necessary for creating the logging table, take following actions:
   1. Click **SQL**. The **Simple SQL editor** opens with DDL (Data Definition Language) generated from the properties of the job.
   2. (Optional) Edit the SQL statements. For details, see [Use the SQL Editor](/pba/pipeline-designer/managing-transformations-and-jobs/use-the-sql-editor.md).
   3. (Optional) To remove stored query results, metadata, or temporary data that the editor has cached from previous SQL executions, click **Clear cache**.
   4. Click **Execute**. The SQL statements run.
8. Click **Save**. The job properties are saved.

## Job properties

The following sections provide a detailed description of the available settings in the Job Properties window:

* [Job tab](#job-tab)
* [Parameters tab](#parameters-tab)
* [Settings tab](#settings-tab)
* [Log tab](#log-tab)
* [Transactions tab](#transactions-tab)

### Job tab

General properties for jobs are found on the **Job** tab.

This table describes all of the general job properties found on the **Job** tab:

| Option                   | Description                                                                                                                |
| ------------------------ | -------------------------------------------------------------------------------------------------------------------------- |
| **Job Name**             | <p>The name of the job.</p><p><strong>Note:</strong> This information is required if you want to save to a repository.</p> |
| **Job filename**         | The file name of the job if it is not stored in the repository.                                                            |
| **Description**          | A user-defined short description of the job which is shown in the repository explorer.                                     |
| **Extended description** | A user-defined longer description of the job.                                                                              |
| **Status**               | The status of the job. The values are **draft** and **production**.                                                        |
| **Version**              | A description of the version.                                                                                              |
| **Directory**            | The directory in the repository where the job is kept.                                                                     |
| **Created by**           | The original creator of the job.                                                                                           |
| **Created at**           | The date and time when the job was created.                                                                                |
| **Last modified by**     | The name of the last user who modified the job.                                                                            |
| **Last modified at**     | The date and time when the job was last modified.                                                                          |

### Parameters tab

You can use the **Parameters** tab to define parameters for your jobs.

This table describes all of the general job properties found on the **Parameters** tab:

| Option            | Description                                      |
| ----------------- | ------------------------------------------------ |
| **Parameter**     | A user-defined parameter.                        |
| **Default value** | The default value of the user-defined parameter. |
| **Description**   | A description of the parameter.                  |

### Settings tab

The following options are available on the **Settings** tab:

| Option                  | Description                                                                                                                                                                                                                           |
| ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Pass batch ID?**      | Select to pass the identification number of the batch to the transformation.                                                                                                                                                          |
| **Shared objects file** | PDI uses a single shared objects file for each user. The default filename is `shared.xml` and is located in the `.kettle` directory in the user’s home directory. You can define a different shared objects file, location, and name. |

### Logging tab

Use the **Logging** tab to specify logging settings.

This table describes all of the general job properties found on the **Log** tab:

| Option                         | Description                                                                                                                                                                                                                    |
| ------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Log connection**             | Specify the database connection you are using for logging. You can configure a new connection by clicking **New**.                                                                                                             |
| **Log Schema**                 | Specify the schema name, if supported by your database.                                                                                                                                                                        |
| **Log table**                  | Specify the name of the log table. f you are also using transformation logging, you must use a different table name for job logging.                                                                                           |
| **Logging interval (seconds)** | Specify the interval in which logs are written to the table. This property only applies to Transformation and Performance logging types.                                                                                       |
| **Log line timeout (days)**    | Specify the number of days to keep log entries in the table before they are deleted. This property only applies to Transformation and Performance logging types.                                                               |
| **Log size limit in lines**    | Enter the limit for the number of lines that are stored in the `LOG_FIELD`. PDI stores logging for the transformation in a long text field (CLOB). This property only applies to Transformation and Performance logging types. |
| **SQL button**                 | Generates the SQL needed to create the logging table and allows you to execute this SQL statement.                                                                                                                             |


---

# Agent Instructions: 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:

```
GET https://docs.pentaho.com/pba/pipeline-designer/working-with-jobs/edit-job-properties.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.