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 out
I 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