question

Bab avatar image
Bab 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?
sql-server-2008-r2
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Kev Riley avatar image
Kev Riley answered
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?
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.