Friday, March 18, 2011

Search for a string in SQL Agent Job Steps



When you change schema of tables or
when you change a SP, you probably need to
to find out whether the SP used in SQL Server
Job(s) or there are inline SQL statements in
the Jobs that use your table(s).






How to do it quickly?

SELECT  js.database_name as DatabaseName,
                 jobs.Name as JobName,
                 js.step_id as StepID,
                 js.step_name as StepName,
                 js.command as StepCommand
FROM     msdb.dbo.sysjobs as jobs
                INNER JOIN msdb.dbo.sysjobsteps as js ON jobs.job_id = js.job_id
WHERE  jobs.[enabled] = 1 AND js.command LIKE  '%XXXXXXXXX%'
ORDER BY jobs.Name,js.step_id

Thanks for reading.

10 comments:

  1. AWESOME! This is a big help!

    ReplyDelete
  2. Perfect, thanks. :)

    ReplyDelete
  3. Exactly what I was needing. Thanks

    ReplyDelete
  4. Saw many online journals. Read numerous works. This is something else. Something astounding.
    resumeyard.com

    ReplyDelete
  5. IPUCET Exam stands for Indraprastha University Common Entrance Exam. This exam is conducted by Guru Gobind Singh Indraprastha University (GGSIPU). The

    IPU CET 2018 Exam is offering admissions to the Under Graduates and Post Graduates in the fields of Engineering, Dental,

    Medical and Law.

    JEE Main is one of the biggest entrance exams that is held every year. The JEE Main 2019 Entrance Examination is

    conducted by the CBSE. This year the CBSE is going to conduct the JEE Main 2019 on April 8th, 2019.

    The CBSE has finally published the Date-sheet of CBSE 10th 2018 Board Exam. The Exam will start from 5th March 2018. Here is the complete list of CBSE Results 2018

    The RRB has announced its Official Advertisement 2018 for Railway Junior Engineer.

    The Recruitment Board is offering approx. 5620 Vacancies for RRB JE. It is a great

    opportunity for those who are interested in the Railway Jobs.

    DMRC (Delhi Metro Rail Corporation) has released the notification for the various

    postsfor Assistant Manager in various fields, Office Assistant, Account Assistant, Stenographer and much more. The Department is providing over 1800 posts

    for the aspiring candidates. The online registration for the recruitment starts from 27th Jan 2018 to 26th Feb 2018 (23:59 pm).Check Here for complete details

    regarding the DMRC Recruitment 2018.

    Recently the RRB has declared the vacancies for the Railway Assistant Station Master

    (ASM). An approx. of 50,000 vacancies, positions are filled this year. full detailed information click here rrb asm recruitment 2018

    The RRB Recruitment Department is planning to release the dates for RRB Recruitment 2018 for the year 2018-19 in the month of January. The examination will be

    conducted after one or two months after the release of the notification. The RRB NTPC 2018 will recruit the candidates for various vacant posts in Technical

    and Non-Technical Categories.

    DMRC (Delhi Metro Rail Corporation) has released the notification for the various

    postsfor Assistant Manager in various fields, Office Assistant, Account Assistant, Stenographer and much more. The Department is providing over 1800 posts

    for the aspiring candidates. The online registration for the recruitment starts from 27th Jan 2018 to 26th Feb 2018 (23:59 pm).Check Here for complete details

    regarding the DMRC Recruitment

    The RRB has announced its Official Advertisement 2018 for Railway Junior Engineer.

    The Recruitment Board is offering approx. 5620 Vacancies for RRB JE Recruitment

    2018
    . It is a great opportunity for those who are interested in the Railway Jobs.

    ReplyDelete
  6. your blog is very nice and very interesting www.aborignaljobcentre.ca

    ReplyDelete
  7. your blog is very nice and very interesting www.aborignaljobcentre.ca

    ReplyDelete
  8. This article is really informative and useful as far as I concern and keep going. sarkari results

    ReplyDelete
  9. Nyc info..
    Government Jobs offer an opportunity to turn your aspirations into reality. If you aspire to work in the mainstream and be a part of the nation's economic development, a job in the Government Sector may be the best option for you. Every year a number of job opportunities become available in the Government Sector.
    for more info:- sarkarijob.ind.in

    ReplyDelete