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
Blackjack, additionally known as twenty-one, is just one of one of the most popular gambling…
If you are a fan of online gambling, then you must have come across gry…
On the internet online casinos have transformed the betting industry, enabling players to vegas.hu online…
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…