Schedule job only on work days

Hi I am using the server agent and have a job scheduled daily but I want it
to only run monday through friday. I did not see this option in the schedule
section of the jobs, just wondering if I would need to put something in the
step section to only execute monday through friday? I currently just have
EXEC storedprocedure1
thanks.
--
Paul G
Software engineer.Paul wrote:
> Hi I am using the server agent and have a job scheduled daily but I want it
> to only run monday through friday. I did not see this option in the schedule
> section of the jobs, just wondering if I would need to put something in the
> step section to only execute monday through friday? I currently just have
> EXEC storedprocedure1
> thanks.
Use a weekly schedule, and just select the days that you want it to run...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||ok thanks for the information. Just wondering if you know if there is a way
to skip holidays?
--
Paul G
Software engineer.
"Tracy McKibben" wrote:
> Paul wrote:
> > Hi I am using the server agent and have a job scheduled daily but I want it
> > to only run monday through friday. I did not see this option in the schedule
> > section of the jobs, just wondering if I would need to put something in the
> > step section to only execute monday through friday? I currently just have
> > EXEC storedprocedure1
> > thanks.
> Use a weekly schedule, and just select the days that you want it to run...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Paul wrote:
> ok thanks for the information. Just wondering if you know if there is a way
> to skip holidays?
You'll have to build your own solution for that, using a calendar table.
Schedule the job to run every day, and the code executed by the job
will have to check the calendar table.
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||ok sounds like a good idea, thanks for the information.
--
Paul G
Software engineer.
"Tracy McKibben" wrote:
> Paul wrote:
> > ok thanks for the information. Just wondering if you know if there is a way
> > to skip holidays?
> You'll have to build your own solution for that, using a calendar table.
> Schedule the job to run every day, and the code executed by the job
> will have to check the calendar table.
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>