Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to find sql server agent jobs related to a database

-- list of jobs; selected info about jobs
SELECT 
 job_id
,name
,enabled
,date_created
,date_modified
FROM msdb.dbo.sysjobs
ORDER BY date_created
Source by www.mssqltips.com #
 
PREVIOUS NEXT
Tagged: #find #sql #server #agent #jobs #related #database
ADD COMMENT
Topic
Name
8+2 =