May 4, 2006 at 9:30 am
Hi i have a Job scheduled in sql server, and that job is scheduled to run every friday at 9.00 PM. Now i need to even schedule it to run every last working day of each month. so my question is if the last working day of a month falls on friday, will my job run twice on that day or will it run only once. Please let me know. What can i do in order to make it run only once. I appreciate any help
Thanks
May 4, 2006 at 9:54 am
Pls don't cross post. We check all forums.
May 4, 2006 at 10:00 am
I am sorry about that. Got confused as to where to post.
May 9, 2006 at 5:27 am
You could try setting up a test where you schedule two jobs to clash to say, increment an integer column in a test table and see what happends. if they clash then you can design the job steps to conditional execute based on querying sysjobs (for job_id GUID based on job name) and sysjobschedules for date/time values, both tables are in msdb. The advanced tab can be set for the job step to conditional execute. Hope this helps.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply