search for text within jobs

[cwbrumett]

I was wondering if there was anyway to search all of the jobs for a table name (or any text for that matter).

something similar to searching DTS via:

http://www.sqlservercentral.com/Forums/Topic181665-8-1.aspx

and searching Sprocs and views

SELECT Distinct SO.Name, SO.Type
   FROM sysobjects SO (NOLOCK)
   INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID
   AND SO.Type IN ( 'P', 'V' )	--search sprocs and views
   AND SC.Text LIKE '%your_text_here%'
   ORDER BY SO.Name

 

[cwbrumett]

I just remembered you can script out all jobs to a file, just do that and search that file.

 

[mrdenny]

You can search the sysjobs and sysjobsteps tables.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog