Just run this against any server. Investigate if the job can be deleted. To be on the safe side, you can always script the job by: Right clicking the job / Script job as / Create to
SELECT @@SERVERNAME SvrName, J.Name, J.[Enabled], JA.LastRun, JA.NextRun, JV.[description], JC.Name JobCategory FROM msdb.dbo.sysjobs J JOIN msdb.dbo.sysjobs_view JV ON J.Job_ID = JV.Job_ID JOIN ( SELECT Job_ID, MAX(Last_Executed_Step_Date) LastRun, MAX(Next_Scheduled_Run_Date) NextRun FROM msdb.dbo.sysjobactivity GROUP BY Job_Id ) JA ON J.Job_ID = JA.Job_ID JOIN msdb.dbo.syscategories JC ON J.Category_ID = JC.category_id WHERE DATEDIFF(m, ISNULL(LastRun, '1900-01-01'), GETDATE()) > 12 OR NextRun < GETDATE()
This article shows how to reduce the periodic spikes in the CPU that are caused by the periodic-executing jobs. There is a good reason to make some changes for dismissing them.
2016-12-20
1,459 reads
Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail
2016-10-28 (first published: 2015-07-28)
16,202 reads
Sometimes we have a T-SQL process that we need to run that takes some time to run or we want to run it during idle time on the server. We could create a SQL Agent job manually, but is there any simple way to create a scheduled job?
2013-10-08
5,394 reads
Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.
2013-09-05
9,613 reads
Red Gate is looking for a Business Intelligence Developer to work with our internal development team on creating business intelligence solutions. You'll be responsible for designing, building, and testing end-to-end BI solutions using the Microsoft BI stack, so we'll expect you to be passionate about understanding data and generating a universe of analytics for your customers – our Red Gaters.
2013-09-04
3,709 reads
