# Job Monitor

The Job Monitor will show information regarding all the jobs to the user. Whether the jobs are in the state of,

* Active
* Running
* Queued
* Successful
* Ending In Errors
* Terminated By Users

The Job Monitor is responsible for storing information on all the jobs associated with the Astera Data Stack server.

## **Methods Of Access**

There are a few ways to access the Job Monitor on your version of Astera.

### **Through Server Explorer**

The Job Monitor can be accessed through the Server Explorer. Simply,

* Go to the *Server Explorer* panel, right-click the *Default* node, and select *Job Monitor* from the context menu.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FsBUJq3L1Z7hIBrjYwnT7%2F0.png?alt=media)

### **Through Astera Toolbar**

The Job Monitor can be accessed through the main menu. Simply,

* Click on the *Server* column on the main menu, and select *Job Monitor* from the drop-down options.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FzS0wNLZCvZPJ2DQOzDyp%2F1.png?alt=media)

### **Job Monitor Toolbar Options**

There are options present on the toolbar of the Job Monitor itself.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FSYnvyu2gWPRjyzGjjilh%2F2.png?alt=media)

* *Show Latest Jobs First/Show Oldest Jobs First*: This option will sort all the jobs on the monitor according to the most recent and oldest.
  * The left-facing arrow sorts the latest jobs towards the top, and the right-facing arrow sorts the oldest jobs towards the top.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FvR51kUNnmHvrcu3Zd11b%2F3.png?alt=media)

* *Pause Auto-Refresh of Job Monitor*: By default, this feature is selected. It will keep the Job Monitor list from automatically refreshing every time a new job is executed while the Job Monitor is open.
  * Unselecting this option will update the Job Monitor list during run-time as jobs are running, scheduled, executed, or failed. It will reset all the filters as well.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FpyelQ9s5HMC0rLuF81DH%2F4.png?alt=media)

* *Show Job Trace for Selected Item*: Selecting this option opens the job progress window. Inside it, we can see the jobs’ steps to end in success/error.
  * The job trace shows us the details of the job.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2F0Dp89LCS8tRDUGaxmaEB%2F5.png?alt=media)

* *Clear Job Queue*: Clear all the jobs that have been put up in a queue to run.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FgbhmItZmoIf7B9LgeMU6%2F6.png?alt=media)

* *Delete Selected Jobs*: All the highlighted jobs are going to be deleted.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2F8dhPrgDIjS1Z176bVUoP%2F7.png?alt=media)

* *Delete All Completed Jobs*: All jobs that have already completed their execution will be deleted.
  * Jobs that are currently running will not be deleted.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FgpsG931eBxKnFks2hr8k%2F8.png?alt=media)

* *Show Root Level Jobs Only*: Selecting this will only display information on root-level jobs. A root-level job is one that does not have a parent assigned.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FsAZcbrM2Dy4CXgFHZJvb%2F9.png?alt=media)

## **Job Monitor Filters**

*Servers*: To select which server the Job Monitor will display information from.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FleXvH4BaQpUC4rwwat7R%2F10.png?alt=media)

*Status*: To filter out jobs based on their status, i.e., Active, Successful, Ending in Errors, etc.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2Fq3AeOP9HGOILXMdX0JUm%2F11.png?alt=media)

*Date Range*: Filtering jobs based on period, i.e., *Today, Yesterday, last month*, etc.

{% hint style="info" %}
**Note:** There is also a *Custom Range* option where the user can provide any custom *Date Range* of their choosing. It will then view only the jobs that fall in that range.
{% endhint %}

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FxkMrLpu5WCc8XhLvQgdX%2F12.png?alt=media)

### **Advanced Search Options**

This option allows the user to extract information from the Job Monitor based on a specific search. It gives the user the ability to retrieve information on a particular search from many options.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FijGZbRfk2HwQwL6qVSgM%2F13.png?alt=media)

14-Advanced-Search

Clicking on this will open a separate panel with additional options,

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FKAJp8BAIyD9qCD0b418b%2F14.png?alt=media)

*Recent Search*: To navigate to a previous search that was already made.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FRJ5yC9hx1lMs8EihTjsK%2F15.png?alt=media)

*Server*: Select the server from which to pull up job information.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FhLjEVtXd0fUMD3Usofo8%2F16.png?alt=media)

### **Additional Options**

* Enter the *Job Name/File Name* to search for it.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FGqH1Q0xrfEkXUoZreuCV%2F17.png?alt=media)

* Select from a list of options under which to search the job, i.e., *Active, Error, Success*, etc., based on the status of the job.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FdAaP97OPgixfaaH8ZvJR%2F18.png?alt=media)

* Other options include a *Job Type* filter, *Date Range* filter, and checkboxes for *My Jobs Only* and *Root Level Jobs Only*

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2F761NpKe5TIEA1UULOc2o%2F19.png?alt=media)

Once done, select *Search*, and it will return the desired results.

![](https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FXE03Dge0OjxrLYardstE%2F20.png?alt=media)

The results are then returned.

## **Job Monitor Context Menu**

The Job Monitor context menu can be accessed by right-clicking anywhere on any job. The context menu can be opened after selecting multiple jobs too.

<figure><img src="https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2Fzefy2v1oasQCDz7aigQJ%2Fimage.png?alt=media&#x26;token=a86d966a-47cf-4cb7-9f54-62d038305134" alt=""><figcaption></figcaption></figure>

* *Rerun Selected Job*: This option is to rerun any selected job.

{% hint style="info" %}
**Note:** This option is not available when multiple jobs are selected.
{% endhint %}

<figure><img src="https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2Fm8mgOR8gmqJW3u1DB6iE%2Fimage.png?alt=media&#x26;token=37e69a53-49e6-4fbe-8580-f6d37f26665b" alt=""><figcaption></figcaption></figure>

*Raise/Lower Job Priority for the Selected Job*: To increase or decrease the priority for any selected job. This will place the job higher or lower on the monitor.

It is only available when the job is in a running state.

<figure><img src="https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FoE927HChp1zcUEoP44YO%2Fimage.png?alt=media&#x26;token=d61fefe7-367f-4647-9052-3d8805fc42a5" alt=""><figcaption></figcaption></figure>

*Show Child Jobs*: Selecting this option will show all child jobs associated with a particular parent job.

<figure><img src="https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2Fy03ALyflZATFkod8MLpb%2Fimage.png?alt=media&#x26;token=6b7461c3-e130-4007-97e1-d68f9073b52c" alt=""><figcaption></figcaption></figure>

*Export To Excel*: To export all the jobs in the Job Monitor to an Excel sheet at a location of your choosing.

<figure><img src="https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2FkG5FlWqDKBnGVn35Iyoo%2Fimage.png?alt=media&#x26;token=ad9a7552-d82a-45db-bd8d-e6078c442859" alt=""><figcaption></figcaption></figure>

## **Job Monitor Columns**

These columns, given in the Job Monitor section itself, contain an extensive set of information regarding each job.

<figure><img src="https://750977703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqHxyVNGb7tSdIWecl6Ru%2Fuploads%2F0ZbM9MHwdqSshcUX0FiT%2Fimage.png?alt=media&#x26;token=8366c01a-c527-4df2-ad0c-02fe10fa3d43" alt=""><figcaption></figcaption></figure>

* *Job Id*: Every Job has a unique Job Id to identify it.
* *Parent*: To signify the parent node of a particular job.
* *Priority*: The level of priority for a given job.
* *Job Type*: To differentiate between types, i.e., Dataflow, Workflow, etc.
* *Server*: Signifies the server on which the job was run.
* *Job File*: The name of the job file.
* *Job Name*: A name that was assigned to the job.
* *Queued*: Timestamp for when a particular job was queued.
* *Started*: Timestamp for when a particular job started
* *Duration*: This signifies how long the job lasted.
* *Status*: The job status, i.e., success, terminated, etc.
* *Scheduled Job*: Displays the scheduled job ID of the scheduled job that ran.
* *Email Status*: Displays the status of the email sent on job conditions if any.
* *Records Read*: The number of records read per job.
* *Error Records*: The number of errors read per job.
* *Warning Records*: The number of warnings read per job.
* *User*: To signify which user performed a particular job.

This concludes our discussion on the Job Monitor in Astera.
