October 9, 2007 at 4:07 am
My boss wanted to run a script in SQL Server Agent. THe catchy part is that he wants the script to run every other week (wednesday 1:00 AM) anyone know how can i do it?? Possible problem is that not all months have the same number of wednesday (there are months with 4, some with 5 wednesday). Thanks in advance
"-=Still Learning=-"
Lester Policarpio
October 9, 2007 at 4:12 am
NO it's not complicated at all.
If you have a look at the scheduling options for weekly jobs you will see the option to run a job every 2 or any other number weeks.
[font="Verdana"]Markus Bohse[/font]
October 9, 2007 at 4:18 am
Hi Lester,
Job schedule should be:
Occurs weekly, every 2 weeks on Wed, Occurs once at 1:00 AM
October 9, 2007 at 7:55 pm
Ahhh ok thanks.... 😛
"-=Still Learning=-"
Lester Policarpio
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply