# 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 server. ### Methods Of Access There are a few ways to access the Job Monitor on your version of Astera Data Stack, #### 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FScT5BNiRiJDNiesDDX72%2F01-Server-Explorer-Job-Monitor.PNG?alt=media\&token=cfbe1d15-d027-4271-b4c2-5f0044bdc1e7) #### Through Astera Top 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fm1oMpn8pTG6AVKGsJQ4Z%2F02-Toolbar-Job-Monitor.PNG?alt=media\&token=bf927921-4e7d-45a8-8a60-714ab4e968d0) ### Job Monitor Toolbar Options There are options present on the toolbar of the Job Monitor itself. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F2egdwFSsY0GgkSgzaj7Z%2F03-Job-Monitor-Toolbar.PNG?alt=media\&token=4cd44bdd-d0e0-4e5b-9271-93a86b261e48) *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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FHtQWVLQGmseiZFjHCm6v%2F04-Latest-Old-Jobs.PNG?alt=media\&token=642ebc52-db14-4f86-a985-4cc5e715b96f) *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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FAO62fHkYvWhdWayQ2ULd%2F05-Pause-Auto-Refresh.PNG?alt=media\&token=bfee4c1d-af81-4bde-81f9-5d7cc4aab105) *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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FZWPLnTAVtkSPwDPPMhaj%2F06-Show-Job-Trace.PNG?alt=media\&token=9d5eee89-3e44-4d70-a844-c3624e738ab1) *Clear Job Queue*: Clear all the jobs that have been put up in a queue to run. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FhKXopDI4vDvfNpKEZFGZ%2F07-Clear-Job-Queue.PNG?alt=media\&token=e5b6ba60-7d61-43e8-82cf-2b4592bf9803) *Delete Selected Jobs*: All the highlighted jobs are going to be deleted. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FnuCxCDlfWuZoguIMZfCF%2F08-Delete-Selected-Jobs.PNG?alt=media\&token=18aefaba-a1df-4a74-b15c-3e0a41c70c7c) *Delete All Completed Jobs*: All jobs which have already completed their execution will be deleted. Jobs that are currently running will not be deleted. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F87NVNf6xY7RggqzaFkw3%2F09-Delete-Completed-Jobs.PNG?alt=media\&token=5266818e-7ac0-4ad7-adc7-638cdfcf8b15) *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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fnq7aA8IzhSrI2tkbvbTi%2F10-Root-Level-Jobs-Only.PNG?alt=media\&token=87a90eb3-f729-4b9b-aac6-4dd8e42cf554) ### Job Monitor Filters *Servers*: To select which server the Job Monitor will display information from. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FDJ2gCTiMAAVyEggtawL0%2F11-Server-Filter.PNG?alt=media\&token=2d25ab12-19e6-4b0b-a1a9-83c09ac83ac2) *Status*: To filter out jobs based on their status, i.e., Active, Successful, Ending in Errors, etc. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fr9cvPIFSbqwdFBYtdTmJ%2F12-Status-Filter.PNG?alt=media\&token=39cfd76e-876c-4f77-b1f4-7652ba6e0590) *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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F0ER6kNww95KTNqu3kVkR%2F13-Date-Filter.PNG?alt=media\&token=64a7fa92-ac85-4143-8d0c-ea69b266f601) #### 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FYKSgMNRgD7SxFQ78iyKf%2F14-Advanced-Search.PNG?alt=media\&token=b74cdfdc-d989-4042-a734-5b9b13fa12b5) Clicking on this will open a separate panel with additional options, ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FzXhEbyFoSa5l6iRzP3XM%2F15-Advanced-Search-Window.PNG?alt=media\&token=f2660005-46bd-498c-b346-e0ba1fb4110a) *Recent Search*: To navigate to a previous search that was already made. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FXcAhaVjxZPIzuLkF1Ccl%2F16-Recent-Search-Edit.PNG?alt=media\&token=001685ce-4b1a-4d0c-a499-8f859dde52d2) *Server*: Select the server from which to pull up job information. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FfWbx7b9TJDrHwSgZVEQI%2F17-server-filter-edit.PNG?alt=media\&token=e8e4d923-2294-49d4-8813-0de57cfa9d95) **Additional Options** * Enter the *Job Name/File Name* to search for it. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FouYyugEh44cFQRVhhCxh%2F18-Enter-Job-Name.PNG?alt=media\&token=a44614dc-c4b0-40ed-8987-1aa4d279262f) * 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FO1xkHean6GKMhRzpsWoj%2F19-Job-Status.PNG?alt=media\&token=6a26f0dd-a67a-4bfa-ab2a-dce7e146ca6d) * Other options include *Job Type* filter, *Date Range* filter, and checkboxes for *My Jobs Only* and *Root Level Jobs Only.* ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F1MKu4e0Eo3BVs8gNlmqb%2F20-Additional-Options-Search.PNG?alt=media\&token=c47b0d34-0c48-4ec0-82a4-8986aeab89e3) Once done, select *Search*, and it will return the desired results. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FLwz4GpeKHiq6FeM2iGEI%2F21-Advanced-Search-Edit.PNG?alt=media\&token=3e555dfa-c35d-4ed0-9e8c-6232336b34c9) The results are then returned. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FTeQDuYnrHMeA0uoYtNHU%2F22-Advanced-Returned-Results-Edit.PNG?alt=media\&token=8e6e1bca-b61b-427e-9d79-ccca7a5a18d0) ### 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. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FskO0m2qHomGfryk6bMSG%2F23-Job-Context-Menu-Edit.PNG?alt=media\&token=01b62f95-0e2c-44a8-8765-d139f3e21e63) *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 %} ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FyundLXq8GGaACSmGMEPi%2F24-Rerun-Context-Menu-Edit.png?alt=media\&token=0aeca813-660b-4a1c-b6ea-6ad6dbfccccf) *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. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FpvIfWiZ0QkN7iKsduVF6%2F25-Job-Priority-Option-Edit.PNG?alt=media\&token=e32af4c5-80bc-4e07-863d-a93953302763) *Show Child Jobs*: Selecting this option will show all child jobs associated with a particular parent job. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F1KRUBzwEcqDcDDFE53vl%2F26-Show-Child-Jobs-Edit.png?alt=media\&token=9b62a810-a336-44cf-ae20-c578734c5911) *Export To Excel*: To export all the jobs in the Job Monitor to an Excel sheet at a location of your choosing. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FD5P8iu81Dg5RWwbinvvP%2F27-Expor-Excel-Edit.png?alt=media\&token=ce94db89-0f2e-40aa-be18-8eaacf871b54) ### **Job Monitor Columns** These columns, given in the Job Monitor section itself, contain an extensive set of information regarding each job. ![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F2esvp80aMYSMA7KpT38A%2F28-Sub-Headings-Job-Monitor.PNG?alt=media\&token=008ff176-5313-444f-a252-05e580b24f0e) *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*: 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.