challening job scheduling question

[equus2]

Hi,

I need a way to change the run time of a job that normally runs at 4:45 am each day.

The catch is, I only want to change the run time on 2 days of the month (which will be dynamically determined each month); so it's not like I know the days before hand.

Help, is there a good way to do this?

Thanks!

 

[macleod1021]

Schedules don't work that well with "dynamic"...they like to be static .

I've never done this before, but I imagine if you have some type of scheduling item that you can modify...like an Outlook Calendar or something, then you could write an app that calls to the SQL Server and runs the job manually.

Personally, I would try to find a way to make the schedule more static.

im in ur stakz, overflowin ur heapz!

 

[mrdenny]

What's the logic that will drive the days when the job needs to be run at the different times?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[equus2]

I found a solution.

I created a "controller job" that calls a stored proc that contains the logic for when to start the "dynamic job". Of course, the job isn't dynamic. The code in the stored proc is "dynamic"... which uses WAITFOR and sp_start_job to start the job based on the logic I want.

Works great. The hard part was writing the logic.