Every so often, my company's BI team will request the today's execution of a job be skipped. What I've been doing in the past, is going into the job schedule and manually changing the schedule's start date to tomorrow. Then, I click on OK on the job schedule to save the schedule edit and then OK on the job properties window.
I then see that the Next Run value change from today at noon to tomorrow at noon which is the desired behavior. Instead of doing it manually, I'd like perform the same task using a script. I tried updating the active_start_date column for the schedule in [msdb].[dbo].[sysschedules] but the job ended up running at noon and it had to be manually stopped.
Does someone know how to effectively skip the next execution for a job through the use of a script?
Environment: SQL Server 2012 SP1