Povratne informacije Uredi

sys.external_streaming_jobs (Transact-SQL)

  • Članak
  • 2 min. za čitanje

Returns a row for each external streaming job created within the scope of the database.

Column name Data type Description
name sysname Name of the stream. Is unique within the database.
object_id int object identification number for the stream object. Is unique within the database.
principal_id int ID of the principal that owns this assembly
schema_id int ID of the schema that contains the object.
parent_object_id id object identification number for the parent object for this stream. In the current implementation, this value is always null
type char(2) Object type. For stream objects, the type is always 'EJ'
type_desc nvarchar(60) Description of the object type. For stream objects, the type is always 'EXTERNAL_STREAMING_JOB'
create_date datetime Date the object was created.
modify_date datetime In the current implementation, this value is the same as the create_date for the stream object
is_ms_shipped bit Object created by an internal component.
is_published bit Object is published.
is_schema_published bit Only the schema of the object is published.
uses_ansi_nulls bit Stream object was created with the SET ANSI_NULLS database option ON
statement nvarchar(max) The stream analytics query text for the streaming job. For more information, see sp_create_streaming_job
status int The current status of the streaming job. The possible values are

Created = 0. The streaming job was created, but has not yet been started.

Starting = 1. The streaming job is in the starting phase.

Failed = 6. The streaming job Failed. This is generally an indication of a fatal error during processing.

Stopped = 4. The streaming job has been stopped.

Idle = 7. The streaming job is running, however there is no input to process.

Processing = 8. The streaming job is running, and is processing inputs. This state indicates a healthy state for the streaming job.

Degraded = 9. The streaming job is running, however there were some non-fatal input/output serialization/de-serialization errors during input processing. The input job will continue to run, but will drop inputs that encounter errors.

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See also