How to Search Text in Steps of SQL Server Agent Jobs - SQL Server Tutorial

How to Search Text in Steps of SQL Server Agent Jobs ?

There could be scenarios when we want to search SQL Server Agent Jobs
Find SQL Server Agent Job if it is using some specific Stored procedure in Job Step Command
Search the SQL Server Agent Job Steps for specific script "Select Count(*) from dbo.Table"
Search for Comments in the queries we have used in SQL Server Agent jobs Steps
and there could be more.

We will be using two system tables to search for the string if it is used in SQL Server Agent Job. SysJobs and SysJobSteps are two system tables which exists in MSDB Database. we can use both of them and get the final results for our requirements. In this example we are searching for string if any job is using "Select count(*) from dbo.Test".

Link for the post with scripts used in this video

Visit us for step by step free tutorials

[krismaly]

Appreciate for educating on sysjobs, sysjobsteps. It was cool.

Thanks

[krismaly]

I enjoyed watching this video. Thanks a lot

[krismaly]

Dear Amir and Raza, you guys are doing good to community. Videos should not lost 10 to 15 mins. try to explain normally encountered errors by intentionally making a mistake. Example omit a comma in a select stmt and so on.

I would appreciate if you could make short videos on
Profiler
Error handling
Problems encountered in SSIS,  SSRS, SSAS and so on...

These are all only suggestions and don't take in other sense.

I enjoy watch your videos and tell my friends.
You can notify me when a video released I can write comments.

Khuda ofis

[krismaly]

I rewatched this video and I like it.


Thanks