Problem solve Get help with specific problems with your technologies, process and projects.

Scheduling jobs to run on alternate Saturdays

1) In Microsoft SQL Server 7.0, how can I schedule the job to run on alternate days? For example, I need to run the job only on the first saturday and the third saturday of the month. How can I schedule it?
2) Is there any way that I schedule the job to not run during a holiday?

1.To accomplish running a job on the first and third Saturday of the month you would create two job schedules.

Here are the steps:

A. On the Job Properties/Schedules tab click the New Schedule button.

B. From the Edit Job Schedule dialog click the Change button.

C. Create a schedule to run the 1st Saturday of every month. Click OK.

D. Repeat steps 1 -- 3 for the third Saturday of the month.

2. As far as I know, there is not a way to suspend a scheduled job from running on certain days.


For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.