check current date
Posted on 2006-06-26
I only want to run some jobs on M - F, excluding the weekends. i also need to exclude holidays.
i'm struggling right now to use my calendar table in the job scheduling, which simply is a calendar table, so to speak, indicative of whether the dates in the table are weekdays, weekends, holidays, etc. Ultimately, I will use this, but right now I really need to modify the job scheduling post haste.
So, in the interim, what's the right way to only invoke the proc if it's M, T, W, Th or F ?
i thought i could just preface it with an IF, making it execute conditionally, but, it's not working. (syntax)
what's the right way to do this?
IF (SELECT datepart(dw, getdate()) BETWEEN 2 AND 6