sys.external_job_streams (Transact-SQL)sys.external_job_streams (Transact-SQL)
为映射到外部流式处理作业的输入或输出外部流对象返回一行。Returns a row each for the input or output external stream object mapped to an external streaming job.
列名称Column name | 数据类型Data type | 说明Description |
---|---|---|
job_idjob_id | intint | 流式处理作业对象的对象标识号。Object identification number for the streaming job object. 此列映射到 sys.external_streaming_jobs 的 object_id 列。This column maps to the object_id column of sys.external_streaming_jobs. |
stream_idstream_id | intint | 流对象的对象标识号。Object identification number for the stream object. 此列映射到 sys.external_streams 的 object_id 列。This column maps to the object_id column of sys.external_streams. |
is_inputis_input | bitbit | 如果将流对象用于流式处理作业的输入,则为 1;否则为 0。1 if the stream object is used an input for the streaming job, otherwise 0. |
is_outputis_output | bitbit | 如果将流对象用于流式处理作业的输出,则为 1;否则为 0。1 if the stream object is used an output for the streaming job, otherwise 0. |
示例Example
此目录视图与 sys.external_streams
和 sys.external_streaming_jobs
目录视图一起使用。This catalog view is used together with sys.external_streams
and sys.external_streaming_jobs
catalog views. 以下显示了一个查询示例A sample query is shown below
Select
sj.Name as Job_Name,
sj.Create_date as Job_Create_date,
sj.modify_date as Job_Modify_date,
sj.statement as Stream_Job_Query,
Input_Stream_Name =
Case js.is_input
when 1 then s.Name
else null
END,
output_Stream_Name =
case js.is_output
when 1 then s.Name
else null
END,
s.location as Stream_Location
from sys.external_job_streams js
inner join sys.external_streams s on s.object_id = js.stream_id
inner join sys.external_streaming_jobs sj on sj.object_id = js.job_id
权限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. 有关详细信息,请参阅 Metadata Visibility Configuration。For more information, see Metadata Visibility Configuration.