Re: SQL Server Job scheduling

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 17:19:00 -0400

Since your company's holidays will differ from mine, there is no magical
inbuilt "work day" calendar. You could create your own, however, and have
the job fire EACH day, calling a stored procedure to check the calendar
table to see if it meets criteria such as "last business day of the
month"...

http://www.aspfaq.com/2519 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"James" <anonymous@discussions.microsoft.com> wrote in message
news:1c42f01c45252$4d8f2840$a501280a@phx.gbl...
> I have a problem with SQL Server job scheduling. As far as
> I know you can not specify a job to be run 'last business
> day of the month'.
>
> This created a problem for me last month. I set the job to
> run 'last weekday of the month' and it ran on 31st of May
> which was a holiday instead of running on the 28th friday
> which was the last business day of the month.
>
> Is there way to make SQL Server jobs to recognize the
> holidays ?? Or even a script ??
>
> Thanks for any help.

Relevant Pages

  • Re: Business/Holiday dates
    ... table and WorkdaysCalendar until those rows are removed from WorkSchedule, ... inserting them into a table of holidays. ... the calendar table is a working day as it is to say every day in a booking ... Dim strCriteria As String ...
    (microsoft.public.access.gettingstarted)
  • Re: Business Day Calculator
    ... a dialog that will let you add additional newsgroups to your post. ... The solution is to create a table storing> all calendar dates, indicating which are business days and holidays, like> this: ...
    (microsoft.public.access.queries)
  • Re: Help with a weekday query
    ... Easiest thing to do is create a table of dates for business days & ... begin_date DATETIME NOT NULL, ... FROM table_name AS T INNER JOIN Calendar As C ... Also holidays would need to be considered. ...
    (microsoft.public.access.queries)
  • Re: Travel and absence calendar
    ... then enter the start and end trip dates and trip destination. ... The calendar will dominantly display Monday through ... Include a table for holidays, a form for entering holidays and the date of ... > designing a travel and absence list/calendar. ...
    (microsoft.public.access.gettingstarted)
  • Re: networkdays
    ... I myself created special 'Calendar' workbook on shared network resource (on ... Table2 (H:J, Holidays): HolidayDate, HolidayName, PreHoliday ... Table3 (L, PreHolidays): PreHoliday ...
    (microsoft.public.excel.worksheet.functions)
Loading