The SQL Agent Jobs panel lists all of the currently defined SQL Agent jobs, highlighting their current status (running, succeeded, or failed). This panel also allows viewing the execution messages from the last run of each job.
This panel allows carrying out tasks described in the following topics:
The SQL Agent Jobs table lists all SQL Server Agent Jobs defined in this server. This table highlights the current status of each job (running, succeeded, or failed). This data is updated on demand.
The job state depends on the last run outcome. For example: if the current status is Completed, but the last run outcome is Fail, the job is indicated by a red circle as a failed job.
The result of the last run (Fail, Success, Retry, Cancel, or In progress). | |
The current status of the job (Running, Completed, or Never Ran). | |
If the job is currently running, displays the current step number. | |
How long the last run took (displayed in the d hh:mm:ss format). | |
The Job Messages table displays the execution messages for each step in the current job. The data in the table is refreshed on demand. Historical data is not stored in a repository.
To create a custom filter for this table, use the options accessible by clicking Advanced. For details, see Components Shared by all Foglight for SQL Server Screens .
The SQL Agent Jobs History chart displays the status of jobs over time, thereby providing the exact information about when a job ran and when it succeeded or failed. The possible statuses are as follows:
• |
• |
• |
• |
• |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center