Windows 2000, SQL server 2000
Is there a way to schedule a SQL server job to only run on M-F. I see
where I can schedule a "daily" job, or weekly or monthly, but I need a
M-F job to run, skipping the weekends.
Any suggestions
Select weekly, have it run every one week, select Mon, Tues,
Wed, Thurs, Friday for the days.
-Sue
On Wed, 25 Jul 2007 18:00:18 -0700, "Den"
<nana-papa@.sbcglobal.net> wrote:
>Windows 2000, SQL server 2000
>Is there a way to schedule a SQL server job to only run on M-F. I see
>where I can schedule a "daily" job, or weekly or monthly, but I need a
>M-F job to run, skipping the weekends.
>Any suggestions
|||Or write a script to ru daily which checks for the day of the week ;-)
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1m5ga395vdsqpoq5rraojb26aacle1hdho@.4ax.com...
> Select weekly, have it run every one week, select Mon, Tues,
> Wed, Thurs, Friday for the days.
> -Sue
> On Wed, 25 Jul 2007 18:00:18 -0700, "Den"
> <nana-papa@.sbcglobal.net> wrote:
>
|||But then you add two useless rows to your history every week...
Aaron Bertrand
SQL Server MVP
> Or write a script to ru daily which checks for the day of the week ;-)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment