To find all jobs owned by a login:
EXEC msdb..sp_help_job
@owner_login_name = N'Login_Name'
GO
Stored procedure sp_help_job returns many other information about SQL Server Agent jobs:
EXEC msdb..sp_help_job
|
|||||
Find all jobs owned by a login in SQL ServerTo find all jobs owned by a login:
Stored procedure sp_help_job returns many other information about SQL Server Agent jobs:
|
|||||
Copyright © 2012 - 2022 SQL Server Administration Blog | zarez.net - All Rights Reserved -
Disclaimer: All information, and code samples, is provided "AS IS" without warranty of any kind. Please verify all the information and code samples before using them. zarez.net shall not be liable for any direct, indirect or consequential damages or costs of any type arising out of using the sample code or any other information from this site. Powered by WordPress & Atahualpa |