Orion.APM.SqlJobInfo
SolarWinds Information Service 2020.2 Schema Documentation
This entity presents SQL agent job information.
Inheritance
Access control
everyone
Properties
| Name | Type | Summary | Access Control |
|---|---|---|---|
| JobInfoID | System.Int32 | The unique integer representation of SQL job. | everyone |
| ApplicationID | System.Int32 | The unique integer representation of application. | everyone |
| LastRunDate | System.DateTime | The date and time of the last SQL agent job execution. | everyone |
| LastRunDuration | System.Int32 | The integer value that contains the last SQL agent job execution duration. | everyone |
| LastRunStatus | System.Int32 | The integer value that contains the last SQL agent job execution status. | everyone |
| Name | System.String | The string value that contains the agent job name. | everyone |
| Status | System.Int32 | The status of an SQL agent job. | everyone |
| DetailsUrl | System.String | URL to agent job details page. Used in alerting. | everyone |
Source Relationships
| Name | Type | Notes |
|---|---|---|
| SqlJobInfoAlert | Orion.APM.SqlJobInfoAlert | Defined by relationship Orion.APM.SqlJobInfoAlertReferencesSqlJobInfo (System.Reference) |
Target Relationships
| Name | Type | Notes |
|---|---|---|
| SqlApplication | Orion.APM.SqlServerApplication | Defined by relationship Orion.APM.SqlServerApplicationHostsSqlJobInfo (System.Hosting) |