Scheduling a Job in sql server

Question

Scheduling a Job in sql server

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739555 More actions · Answer 1

Schedule it twice, once for Fris, once for EOM. Be sure the time on the day for EOM is later than the one for Fris. Then add logic to the EOM one that doesn't run the job if it's Fri. Maybe a step before that checks for datepart(wd, getdate()) = Friday. If so, return an error so the job doesn't run. Be sure you end the job on step failures.

pinky SSCommitted Points: 1997 More actions · Answer 2

Thanks for your reply. I have my JOB scheduled in SQL Server agent. Can you pelase explain me as to how can i add that step in that job to fail if the EOM is Friday.