Recentemente eu me deparei com uma atividade onde eu tinha que encontrar em todos os jobs agendados uma tabela específica para saber quais jobs utilizavam aquela tabela. Se você quer encontrar alguma tabela, view, procedure, ou qualquer texto específico nos passos dos jobs veja aqui esse script que vai resolver seus problemas.
SQL Server 2005 +
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'%O_QUE_PROCURA%' GO
SQL Server 2000
USE [msdb] GO SELECT j.job_id, j.originating_server, j.name, js.step_id, js.command, j.enabled FROM dbo.sysjobs j JOIN dbo.sysjobsteps js ON js.job_id = j.job_id WHERE js.command LIKE N'%O_QUE_PROCURA%' GO
Casinos online offer free spins to draw new customers. These bonuses are usually very profitable,…
In recent times, online casino sites have actually obtained enormous appeal among gamers, providing a…
Bitcoin, the most preferred cryptocurrency worldwide, has reinvented lots of industries, including the on baixar…
Online slots have turned into one of one of the most preferred forms of home…
Port video games have actually long been a popular type of entertainment, providing exhilarating gameplay…