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 schedul
e
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 i
t
> to only run monday through friday. I did not see this option in the sched
ule
> section of the jobs, just wondering if I would need to put something in th
e
> 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:
> 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 w
ay
> 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:
> 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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment