Q

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

This was first published in April 2002

Dig deeper on Microsoft SQL Server Installation

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close