Scheduling a Job in SQL server

  • Pls don't cross post. We check all forums.

  • I am sorry about that. Got confused as to where to post.

  • 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 3 posts - 1 through 4 (of 4 total)

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