Job Scheduler

Hello,
Is it possible for me to schedule a job that runs @. 8 AM, 11 AM & 2 PM for
the first three weeks of the month and for the last week of the month have
the job run every 90 minutes.
Thanks in advance
stone outI doubt that you can do that via EM. Perhaps you wil, have to run some
script that determines a week's number and changes the schedule accordingly
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:81122877-29AB-4F21-82E0-A0F6F337269D@.microsoft.com...
> Hello,
> Is it possible for me to schedule a job that runs @. 8 AM, 11 AM & 2 PM for
> the first three weeks of the month and for the last week of the month have
> the job run every 90 minutes.
> Thanks in advance
> stone out|||You may be able to do this with multiple schedules.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:81122877-29AB-4F21-82E0-A0F6F337269D@.microsoft.com...
> Hello,
> Is it possible for me to schedule a job that runs @. 8 AM, 11 AM & 2 PM for
> the first three weeks of the month and for the last week of the month have
> the job run every 90 minutes.
> Thanks in advance
> stone out|||stoney wrote:
> Hello,
> Is it possible for me to schedule a job that runs @. 8 AM, 11 AM & 2
> PM for the first three weeks of the month and for the last week of
> the month have the job run every 90 minutes.
> Thanks in advance
> stone out
Set up the schedule to run every 90 minutes. Using T-SQL, determine
where you are in the month and complete or terminate the script
accordingly.
David Gugick
Quest Software
www.imceda.com
www.quest.com