Exclude Day from Scheduled Job

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sql Junkie-204042 Hall of Fame Points: 3874 More actions · Answer 1

In the job schedule option (in Job properties), change the Frequnecy from Daily to weekly and check all days except Saturday.

deucellion Say Hey Kid Points: 680 More actions · Answer 2

Say Hey Kid

Points: 680

August 15, 2007 at 6:26 am

thank you

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

And here I was going to give some fancy T-SQL to check and then fail the step if it was a Sat.

Nice solution, sql_junkie!