Re: SQL Server Job scheduling

From: Gregory A. Larsen (greg.larsen_at_netzero.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 14:14:14 -0700

In order to do what you are asking you would first need to establish a
business day calendar. From this calendar you could then derive the
schedule for your job, and use the "sp_add_jobschedule" sp to schedule the
jobs. Or have a job that runs every day, and when it detects the last
working day of the month, using the business day calendar, the sp then use
"sp_start_job", to start your end of month processing. Of course what I am
suggesting is basically a homegrown scheduling process. 

-- 
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"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

  • daily calendar view
    ... Is there a way that I can set my calendar to show only the hours of operation ... I am currently using outlook to schedule ... appointments in a service based business, we only schedule between the hours ... Is there any way that I can format my daily view to see only ...
    (microsoft.public.outlook.calendaring)
  • Re: i was clutching to attribute you some of my allied worths
    ... please pronouncing sediment for instance my calendar. ... Whoever divert once, widen so, then schedule around the abortion ... Fucking don't buy reportedly while you're scaning below a delightful ... Many behalfs very sigh the puzzled campaign. ...
    (sci.crypt)
  • RE: What am I doing wrong tracking progress?
    ... to record it in the schedule. ... calendar Either create a new calendar ... Project and tell it, "My resource worked on this task for six hours, ... The correct amount of work for the task is ...
    (microsoft.public.project)
  • Re: Outlook and dates
    ... If a task positively can only take place on the first of the month, create a calendar that shows the first of each month as the only working day and assign that calendar as the task calendar for the task of interest. ... Then the only days it will be scheduled on will be the first of the month - if its predecessor finishes the 15th of August, that task will be scheduled the 1st of September. ... If the contract requires you to ship on the 1st of September, it's up to you to arrange the predecessors and schdule their resources so its possible to ship on schedule - merely fixing the ship date to September 1 won't make it happen. ...
    (microsoft.public.project)
  • Re: Insurance and donations
    ... I view insurance as protection on items that a) I ... business, and pursue it as such (record keeping is very important to ... equipment I'd include in schedule C. ... anywhere to deduct such a charitable gift. ...
    (alt.guitar.bass)