Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs, ROOT\CIMV2

Class | Methods | Properties (16) | Qualifiers (12) | Instances | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Description

SQLAgent General Statistics about jobs

Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs properties

Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs has 16 properties (7 Local, 9 Derived)

Name	Origin	CIMType
Activejobs	Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs	21 [uint64]
Caption	CIM_StatisticalInformation	8 [string]
Description	CIM_StatisticalInformation	8 [string]
Failedjobs	Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs	21 [uint64]
Frequency_Object	Win32_Perf	21 [uint64]
Frequency_PerfTime	Win32_Perf	21 [uint64]
Frequency_Sys100NS	Win32_Perf	21 [uint64]
JobsactivatedPerminute	Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs	21 [uint64]
Jobsuccessrate	Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs	21 [uint64]
Jobsuccessrate_Base	Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs	21 [uint64]
key Name	CIM_StatisticalInformation	8 [string]
Queuedjobs	Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs	21 [uint64]
Successfuljobs	Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs	21 [uint64]
Timestamp_Object	Win32_Perf	21 [uint64]
Timestamp_PerfTime	Win32_Perf	21 [uint64]
Timestamp_Sys100NS	Win32_Perf	21 [uint64]

Detailed description of Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs properties

Local properties (7) of Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs class

▲ Activejobs property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	0
Description	'Number of running jobs.'
DetailLevel	100
DisplayName	'Active jobs'
DisplayName009	'Active jobs'
HelpIndex	0
PerfDefault	True
PerfIndex	0
Activejobs property is in 2 classes of ROOT\cimv2 and in 1 namespace

▲ Failedjobs property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	0
Description	'Number of failed jobs.'
DetailLevel	100
DisplayName	'Failed jobs'
DisplayName009	'Failed jobs'
HelpIndex	0
PerfIndex	0
Failedjobs property is in 2 classes of ROOT\cimv2 and in 1 namespace

▲ JobsactivatedPerminute property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	0
Description	'Number of jobs activated within the last minute.'
DetailLevel	100
DisplayName	'Jobs activated/minute'
DisplayName009	'Jobs activated/minute'
HelpIndex	0
PerfIndex	0
JobsactivatedPerminute property is in 2 classes of ROOT\cimv2 and in 1 namespace

▲ Jobsuccessrate property
CIMTYPE	'uint64'
CounterType	537003264
DefaultScale	0
Description	'Percentage of successful jobs from the total number of executed jobs.'
DetailLevel	100
DisplayName	'Job success rate'
DisplayName009	'Job success rate'
HelpIndex	0
PerfIndex	0
Jobsuccessrate property is in 2 classes of ROOT\cimv2 and in 1 namespace

▲ Jobsuccessrate_Base property
CIMTYPE	'uint64'
CounterType	1073939712
DefaultScale	0
Description	''
DetailLevel	100
DisplayName	''
DisplayName009	''
HelpIndex	0
PerfIndex	0
Jobsuccessrate_Base property is in 1 class (Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs) of ROOT\cimv2 and in 1 namespace

▲ Queuedjobs property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	0
Description	'Number of jobs queued.'
DetailLevel	100
DisplayName	'Queued jobs'
DisplayName009	'Queued jobs'
HelpIndex	0
PerfIndex	0
Queuedjobs property is in 2 classes of ROOT\cimv2 and in 1 namespace

▲ Successfuljobs property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-2
Description	'Number of successful jobs.'
DetailLevel	100
DisplayName	'Successful jobs'
DisplayName009	'Successful jobs'
HelpIndex	0
PerfIndex	0
Successfuljobs property is in 2 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs class

▲ Caption property
CIMTYPE	'string'
Description	'A short textual description (one-line string) for the statistic or metric.'
MaxLen	64
read	True
Caption property is in 1050 classes of ROOT\cimv2 and in 37 namespaces

▲ Description property
CIMTYPE	'string'
Description	'A textual description of the statistic or metric.'
read	True
Description property is in 1061 classes of ROOT\cimv2 and in 142 namespaces

▲ Frequency_Object property
CIMTYPE	'uint64'
Frequency_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces

▲ Frequency_PerfTime property
CIMTYPE	'uint64'
Frequency_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces

▲ Frequency_Sys100NS property
CIMTYPE	'uint64'
Frequency_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces

▲ Name property
CIMTYPE	'string'
Description	'The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property. '
key	True
MaxLen	256
read	True
Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces

▲ Timestamp_Object property
CIMTYPE	'uint64'
Timestamp_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces

▲ Timestamp_PerfTime property
CIMTYPE	'uint64'
Timestamp_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces

▲ Timestamp_Sys100NS property
CIMTYPE	'uint64'
Timestamp_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces

Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs Qualifiers

Name	Value	ToInstance	ToSubclass	Overridable	Amended	Local
Description	'SQLAgent General Statistics about jobs'	✓	✗	✓	✓	✓
DetailLevel	100	✓	✗	✓	✗	✓
DisplayName	'SQLAgent:Jobs'	✓	✗	✓	✓	✓
DisplayName009	'SQLAgent:Jobs'	✓	✗	✓	✗	✓
dynamic	True	✓	✗	✓	✗	✓
GenericPerfCtr	True	✓	✗	✓	✗	✓
HelpIndex	0	✓	✗	✓	✗	✓
HiPerf	True	✓	✗	✓	✗	✓
Locale	1033	✓	✗	✓	✓	✓
PerfIndex	0	✓	✗	✓	✗	✓
provider	'WmiPerfInst'	✗	✗	✓	✗	✓
RegistryKey	'SQLSERVERAGENT'	✓	✗	✓	✗	✓

Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs System properties

Name	Value	Origin	CIMType	Local	Array
__PATH	'\\.\ROOT\cimv2:Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs'	___SYSTEM	8	✗	✗
__NAMESPACE	'ROOT\cimv2'	___SYSTEM	8	✗	✗
__SERVER	'.'	___SYSTEM	8	✗	✗
__DERIVATION	['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']	___SYSTEM	8	✗	✓
__PROPERTY_COUNT	16	___SYSTEM	3	✗	✗
__RELPATH	'Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs'	___SYSTEM	8	✗	✗
__DYNASTY	'CIM_StatisticalInformation'	___SYSTEM	8	✗	✗
__SUPERCLASS	'Win32_PerfRawData'	___SYSTEM	8	✗	✗
__CLASS	'Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs'	___SYSTEM	8	✗	✗
__GENUS	1	___SYSTEM	3	✗	✗

Similar Classes to Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobs

Number of classes:3

Class name	Childs	Properties	Methods	Class Instances	Child Instances	Abstract	Singleton
Win32_PerfFormattedData_SQLSERVERAGENT_SQLAgentJobs	0	15	0	-	-	-	-
Win32_PerfFormattedData_SQLSERVERAGENT_SQLAgentJobSteps	0	12	0	-	-	-	-
Win32_PerfRawData_SQLSERVERAGENT_SQLAgentJobSteps	0	12	0	-	-	-	-