Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql agent jb is enabled query

view sourceprint?
1.
SELECT @@servername, [name] as 'job name', [enabled] as 'enabled'
2.
FROM msdb.dbo.sysjobs
Source by www.sqlserver-dba.com #
 
PREVIOUS NEXT
Tagged: #sql #agent #jb #enabled #query
ADD COMMENT
Topic
Name
7+1 =