asked
Running SQL job more frequently
I am trying to find if running the jobs more frequently create any issues or cause any problems to the maintenance plan jobs in the server. I need to create a job that runs every 10 minutes 24 hours a day. will that cause any problem and impact any maintenance plan jobs that backup the database every night?
Typically, running a job every 10 minutes will not affect a backup that is part of a maintenance plan. Backups represent a consistent picture of your database at a given time. A backup can take hours to run (if your database is large enough), but normal operation can still run during that time. However, having said that, it does depend on what this job will be doing... Also what else is in your maintenance plans?
14 People are following this question.
