June 16, 2009 at 9:33 am
I've written only a few scheduled jobs that run in SQL Server's SQL Agent. One of these runs the first day of each quarter, which adds funds to various columns of tables, for the rest of the quarter. (I work for a nonprofit, and so we've got to meter out the money we receive, in a manner to ensure it will last throughout the fiscal year.) Anyway, I wrote this job about 10 months ago, and its worked fine ever since. I love it. But we're nearing the end of the last quarter in our fiscal year, and so things change for the change in fiscal year. It is my intention to write another SQL script to update relevant tables for the new fiscal year, etc. So, in this case it will be a onetime thing, and therefore I don't want my run on the first day of the quarter SQL job to run. But, I do want it to stay on schedule, so that it will run, as expected, on October 1.
So, in order to do this, would I go into the Jobs under SQL Server Agent, and just comment out the commands on each of the steps in the job? I figured if I did that, then the job would run as normal, on July 1, and do nothing, but will then be schedule appropriately to run again on October 1. Then after July 1 I could uncomment the commands and I've be good to go for October 1.
Kindest Regards, Rod Connect with me on LinkedIn.
June 16, 2009 at 9:41 am
right click on the job and click disable.
June 16, 2009 at 9:53 am
Jobs and schedules can be enabled or disabled independently, so you can disable the job as Pradeep suggested and leave the schedule untouched. After July 1, just enable the job and you're ready to go for the next quarterly run.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply