Say there is a SSIS job scheduled to run every 10 minutes. Under normal circumstances it takes 2 minutes for a job to complete. However, on rare occasion (for the reasons outside of my control) it may take up to 15 minutes to complete. Business logic is such that starting new job when previous is still running is not acceptable. Is there some recommended way to prevent next scheduled job if previous is still running?

If you are using SQL Agent to run the SSIS job, then you will not be able to run the job a second time if the job is still running.Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers