Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
View jobs
USE [msdb] GO SELECT j.job_id, s.srvname, j.name, js.step_id, js.command, j.enabled FROM dbo.sysjobs j JOIN dbo.sysjobsteps js ON js.job_id = j.job_id JOIN master.dbo.sysservers s ON s.srvid = j.originating_server_id --WHERE js.command LIKE N'%KEYWORD_SEARCH%' GO
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Try_Parse (Type Casting )
Recursion and cte
NAMES
SQL left join
Rextester implements OUTPUT feature of Update ~ Delete (2016 >)
Stuff
try catch, raiserror and throw
SQL for beginners( defined with errors while enforcing constraints)
Arun
database size
Please log in to post a comment.