When you have a job that needs to be scheduled outside of the normal allowed schedules provided by em or ms, this works great...simple if statement that calls job by name on certain dates.
if datepart(month, getdate()) = 1 and datepart(d, getdate()) in (6,11) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 2 and datepart(d, getdate()) in (7,17) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 3 and datepart(d, getdate()) in (7,23) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 4 and datepart(d, getdate()) in (7,21) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 5 and datepart(d, getdate()) in (5,20) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 6 and datepart(d, getdate()) in (7,22) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 7 and datepart(d, getdate()) in (7,21) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 8 and datepart(d, getdate()) in (5,23) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 9 and datepart(d, getdate()) in (7,22) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 10 and datepart(d, getdate()) in (5,21) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 11 and datepart(d, getdate()) in (4,18) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here' if datepart(month, getdate()) = 12 and datepart(d, getdate()) in (7,21) EXEC msdb.dbo.sp_start_job @job_name = 'Job Name Here'
This script adds empty first step for every job for easier job history viewing.
2015-12-28 (first published: 2015-12-10)
1,847 reads
This script will break job schedules down into a readable format (msdb.dbo.sysschedules)
2010-01-06 (first published: 2009-12-16)
1,948 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
10,428 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
