How to Search Text in Steps of SQL Server Agent Jobs

We are planning to change the name of a table, we have checked the dependencies and searched in sys.sql_modules if this table is used in any other object so we can take care of it. We also want to make sure if this table is used directly in any SQL Server Agent Job.

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".

USE msdb

GO

 SELECT Job.name          AS JobName,
       
Job.enabled       AS ActiveStatus,
       
JobStep.step_name AS JobStepName,
      
JobStep.command AS JobCommand
 FROM   sysjobs Job
       
INNER JOIN sysjobsteps JobStep
               
ON Job.job_id = JobStep.job_id 
WHERE  JobStep.command LIKE '%Select count(*) from dbo.Test%'  --You can change here what you are searching for

Search SQL Server Agent Job Steps for Specific Text

60 comments:

  1. This is a great post and I read a way while back. It really helped me out.Thank you so much for this great article.
    SEO Tool
    wordpress theme

    ReplyDelete
  2. Thank you for excellent article.I enjoyed reading your blog!!

    Please refer below if you are looking for best Civil and Mechanical courses in Coimbatore

    AutoCAD training in Coimbatore | ArchiCAD training in Coimbatore|AutoCAD RCC Detailing training in Coimbatore|Ansys Workbench training in Coimbatore

    Keep the good work and write more like this..

    ReplyDelete
  3. I am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. Text marketing automation tool

    ReplyDelete
  4. Most of the blogs pretend themselves as most usable and updated blogs with new information but sometime truth might different. I want to share some facts related to this subject which will help people to enhance their skills.
    Find job on experts24hr

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. This is very interesting, but it is necessary to click on this link: cheap dedicated server germany

    ReplyDelete
  7. Importance – Some specialists guarantee that the associations occupied with information mining don't have to concentrate on DA. Data Analytics Course

    ReplyDelete
  8. They will be able to run their mind over many different points of view and to come to their own conclusion. If they only had access to one point of view, it would be a lot harder for them to know whether or not it is accurate.
    Bobby White

    ReplyDelete
  9. The articles can contain general data about points your clients may be keen on. On the off chance that you do it compose with earnest enthusiasm for your clients prosperity this achievement can be accomplished agreeable to you. blog comments service in 1$

    ReplyDelete
  10. You the Affiliate Marketers will discover handpicked tips, instruments and assets for your utilization SEO PACKAGE

    ReplyDelete
  11. you can contract a Ghost author or a Company who manages web crawler arranged catchphrase arrive at content and write to expandBacklinks service

    ReplyDelete
  12. I have bookmarked your website because this site contains valuable information in it. I am really happy with articles quality and presentation. Thanks a lot for keeping great stuff. I am very much thankful for this site. hotmail-inicio-sesion.com/

    ReplyDelete
  13. Thank you for your post.Really looking forward to read more. Cool.satta king

    ReplyDelete
  14. At once the blog might possibly unquestionably pick up famed very from post the general public, as for the meticulous content articles or maybe just necessary review articlesSatta king

    ReplyDelete
  15. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
    data analytics course

    ReplyDelete
  16. The triumphant numbers are settled on an arbitrary premise just as hence, numbers picked by you haphazardly may end up having far superior odds of winning than any arrangement of carefully arranged just as planned numbers.satta king

    ReplyDelete
  17. This is exactly the information I'm looking for, I couldn't have asked for a simpler read with great tips like this... Thanks! ExcelR Data Analytics Courses In Pune

    ReplyDelete
  18. # 1 is often the capacity along with the technical specs in the servers for you to shall be using ark server hosting

    ReplyDelete
  19. It is not a question anymore of "Do I need SEO?" Most companies have seen their competitors gain leads, more customers, more sales, etc. from SEO services. The present question companies are asking themselves, is "Should I outsource SEO?" This article outlines the benefits of outsourcing SEO services, as opposed to hiring an SEO Specialist in-house.
    מסה מדיה קידום בגוגל

    ReplyDelete
  20. Know more about Data Analytics
    Cool stuff you have, and you keep overhaul every one of us.

    ReplyDelete
  21. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. keep it up.
    data analytics course in Bangalore

    ReplyDelete
  22. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. keep it up.
    data analytics course in Bangalore

    ReplyDelete
  23. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data Science Course

    ReplyDelete
  24. Your blog is in a convincing manner, thanks for sharing such an information with lots of your effort and time sql dba training

    ReplyDelete
  25. Thank you, it helped me a lot.

    ReplyDelete
  26. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data Science Course

    ReplyDelete
  27. You guardians do an astounding web diary, and have some unfathomable substance. Continue doing extraordinary. https://serverbrowse.com/

    ReplyDelete
  28. Your post is very helpful to get some effective tips to reduce weight properly. You have shared various nice photos of the same. I would like to thank you for sharing these tips. Surely I will try this at home. Keep updating more simple tips like this.  https://serverbrowse.com/

    ReplyDelete
  29. Facilitating of a solitary or a few sites. In this sort of arrangement, the entirety of the administrations/programs are introduced and running on one dedicated server. High Performance Dedicated Servers

    ReplyDelete
  30. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  31. This blog is so nice to me. I will keep on coming here again and again. Visit my link as well.. drip likes instagram

    ReplyDelete
  32. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  33. Your blog is in a convincing manner, thanks for sharing such an information with lots of your effort and time
    sql server dba online training

    ReplyDelete
  34. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.
    data analytics courses

    ReplyDelete
  35. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression
    data science interview questions

    ReplyDelete
  36. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  37. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    mulesoft online training
    best mulesoft online training
    top mulesoft online training

    ReplyDelete
  38. Thank you so much for this nice information. Hope so many people will get aware of this and useful as well. And please keep update like this.

    Text Analytics Companies

    Text Analytics Tool

    ReplyDelete
  39. Welcome To www.sattaking-online.in

    Considerable Guidelines to be able to Acquire Black Satta King game Effortlessly!

    You'll look at a couple of Black Satta King suggestions and also deceives to work with to your Black Satta King match up taking over specifications. Become in which as it can, its not all web sites would certainly have the option take into consideration your specific wants and also requirements in the right way. Consequently, you must look at the appropriate web site for your action. It will be in your very best edge to be able to gain whenever you can from your suggestions and also deceives within your munitions stockpile to be able to control Black Satta King complements effectively. You must feel the accrued details to analyze the upcoming along with preserving handle of one's thoughts which could modify the upcoming.

    Correcting Black Satta King quantities regarding recuperating the particular misfortunes:

    You'll stepped on a couple of web sites that will offer you repaired Black Satta King quantities. You'll have the option to minimize their particular misfortunes to be able to top Black Satta King's final results. These kinds of quantities could be produced available in Kalyan Black Satta King, the standard Black Satta King video game along with several types of Black Satta King. The particular considerable level regarding vendors would-be participants to work with repaired Black Satta King quantities must control the particular match up. They might support participants together with turning into Satta master.

    Doing well inside the estimating and also excellent view Satta game:

    A significant technique for successful inside the spherical regarding Black Satta King would certainly become a member of the particular ideas and also reputation regarding brain in the feasible approach. Black Satta King estimating would certainly give you needed benefits. Whatever the case, choosing needed to use appear view plus a fantastic puzzle to be able to acquire the most effective benefits. Experts would certainly have the option to assist you simply by supplying differing types regarding suggestions along with charts, as an example, the particular Black Satta King summarize to your edge. The particular experts and also summary web site would certainly provide finest suggestions and also deceives for your participants to work with you together with contributing to a new player profitable in the effective approach. Medicine to grab rewards, the misfortunes would certainly obviously go down.

    Settle on your fortunate number:

    On the level once you feel the charts, buying the particular privileged amount would certainly turn into typically less difficult to suit your needs. These kinds of chart could be extensive regarding equally Black Satta King sets out along with traditional Black Satta King charts. You must feel the offered info and also crucial information to find aid around the privileged amount.

    Any time expecting buying an educated selection around the chosen amount to bring an individual excellent karma, you'll demand examining the particular gambling routine along with having the suggestions coming from diverse experts. Merely a top quality and also trustworthy web site would certainly have the option to offer important and also crucial info about diverse recommendations on differing with the Black Satta King game.

    Almost everybody on earth continues to be wishing to boost further compensation/pay by means of On the web Black Satta King. Since globalization and also urbanization are usually by means of, charges are usually growing then one wage supply just isn't enough to aid family members.

    ReplyDelete
  40. Welcome To www.sattaking-online.in

    Significant Tips and Tricks to Win Satta King Game Easily!

    You would go over a few Satta King tips and deceives to utilize for your Satta King match dominating requirements. Be that as it may, not all sites would have the option to take into account your particular needs and prerequisites in the correct way. Accordingly, you ought to think about the correct site for the activity. It would be to your greatest advantage to benefit as much as possible from the tips and deceives in your munitions stockpile to dominate Satta King matches correctly. You ought to experience the accumulated information to investigate your future alongside keeping control of your feelings that could change your future.

    Fixing Satta King numbers for recuperating the misfortunes

    You would run over a few sites that would offer fixed Satta King numbers. You would have the option to lessen their misfortunes to outdo Satta King's results. Such numbers would be made accessible in Kalyan Satta King, a conventional Satta King game alongside different types of Satta King. The significant point of suppliers would-be players to utilize fixed Satta King numbers should dominate the match. They would assist players with becoming Satta lord.

    Succeeding in the speculating and good judgment game

    A decent technique for thriving in the round of Satta King would join the theories and presence of mind in a viable way. Satta King speculating would offer you wanted outcomes. In any case, you would be required to apply sound judgment and a great mystery to procure the best outcomes. Specialists would have the option to help you by furnishing different sorts of tips alongside graphs, for example, the Satta King outline for your advantage. The specialists and subjective site would offer the best tips and deceives for the players to assist you with bringing about a player winning in a persuading way. When you begin to pick up benefits, your misfortunes would naturally descend.

    Settle on your fortunate number

    At the point when you experience the graphs, settling on the fortunate number would turn out to be generally simpler for you. These charts would be comprehensive of both Satta King outlines alongside customary Satta King graphs. You ought to experience the given data and imperative details to look for help on the fortunate number.
    When anticipating settling on an educated choice on the picked number to bring you good karma, you would require checking the gaming pattern alongside getting the tips from different specialists. Just a quality and dependable site would have the option to give you pertinent and essential data on different tips on various parts of the Satta King game.

    Almost everybody on the planet has been longing to increase additional compensation/pay through Online Satta King. As globalization and urbanization are through, costs are rising and one salary stream isn't sufficient to help families.

    Most people at that point keep on working through various business sources and low maintenance occupations. However, they feel worn out and depleted following a persevering day. In this manner, taking care of another assignment is overwhelming because it adds to previously existing passionate and physical inconvenience.

    The vast majority of the individuals like to play Satta King because it's a practically basic game that incorporates speculating numbers from 0–9. Anybody can turn into an ace of Satta King with a little investigation of aides and practice. It is the truthfulness of the game that has picked up it is monstrously well known among individuals. In any case, many individuals are playing this game in their standard life since it's an exceptionally intriguing game.


    ReplyDelete
  41. I must say, I thought this was a pretty interesting read when it comes to thisC topic. Liked the material. . .
    satta king online

    ReplyDelete
  42. Thanks for your valuable information. Contextread is the leading content writing company in bangalore, India. Our content writers in bangalore   not only writing SEO friendly content for your website but also attract more potential customers to your website organically through our online content marketing services. We are the best-rated content writing agency in Bangalore India for creative content creation. Hire contextread content writing services in bangalore for plagiarism-free high-quality content

    ReplyDelete

  43. Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
    Msbi online training Hyderabad
    Msbi online training India
    Msbi online course
    Msbi course
    Msbi training
    Msbi certification training

    ReplyDelete
  44. machine learning, the major programming language that is been used is Python, and one can find many libraries dedicated to machine learning only. unindent does not match any outer indentation level python

    ReplyDelete
  45. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  46. I feel a lot more people need to read this, very good info! . . .
    토토사이트

    ReplyDelete
  47. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  48. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Simple Linear Regression
    Correlation vs covariance
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  49. Your post was very nicely written. I’ll be back in the future for sure!
    แทงไฮโล

    ReplyDelete
  50. Most of the blogs pretend themselves as most usable and updated blogs with new information but sometime truth might different. I want to share some facts related to this subject which will help people to enhance their skills.
    how changes are handled

    ReplyDelete
  51. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete