{"id":1735,"date":"2025-06-18T20:36:20","date_gmt":"2025-06-18T20:36:20","guid":{"rendered":"https:\/\/www.versionsql.com\/help\/documentation\/features\/automatic-scheduled-commits\/"},"modified":"2025-06-18T21:11:25","modified_gmt":"2025-06-18T21:11:25","slug":"automatic-scheduled-commits","status":"publish","type":"docs","link":"https:\/\/www.versionsql.com\/help\/documentation\/features\/automatic-scheduled-commits\/","title":{"rendered":"Automatic Scheduled Commits"},"content":{"rendered":"<p data-pm-slice=\"1 1 []\">VersionSQL\u202f can commit database changes automatically on a schedule you define.<\/p>\n<h2>Why use it?<\/h2>\n<ul data-spread=\"false\">\n<li>Keep version control current without manual clicks.<\/li>\n<li>Reduce &#8220;oh\u2011no&#8221; moments when you forget to commit changes at the end of a day.<\/li>\n<\/ul>\n<h2>Enabling scheduled commits<\/h2>\n<ol start=\"1\" data-spread=\"false\">\n<li>In <strong>Object\u00a0Explorer<\/strong>, right\u2011click the target database \u2192 <strong>Edit\u202fVersion\u00a0Control\u202fSettings<\/strong>.<\/li>\n<li>Click <strong>Advanced\u202fOptions<\/strong> \u2192 <strong>Schedule<\/strong> tab.<\/li>\n<li>Tick <strong>Automatically commit on schedule<\/strong>.<\/li>\n<li>Choose:\n<ul data-spread=\"false\">\n<li><strong>Time of day<\/strong><\/li>\n<li><strong>Days of week<\/strong> (one or many)<\/li>\n<\/ul>\n<\/li>\n<li>Click <strong>OK<\/strong> to save.<\/li>\n<li>Leave SSMS open. VersionSQL checks schedules every 5\u202fminutes and will launch the commit automatically when the time arrives.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1738\" src=\"https:\/\/www.versionsql.com\/help\/wp-content\/uploads\/2025\/06\/scheduled_commits.png\" alt=\"\" width=\"471\" height=\"249\" srcset=\"https:\/\/www.versionsql.com\/help\/wp-content\/uploads\/2025\/06\/scheduled_commits.png 471w, https:\/\/www.versionsql.com\/help\/wp-content\/uploads\/2025\/06\/scheduled_commits-300x159.png 300w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/p>\n<h2>What gets committed?<\/h2>\n<ul data-spread=\"false\">\n<li>All objects that would normally appear in the manual commit dialog for that database.<\/li>\n<li>Commit message is autogenerated: <code>VersionSQL Scheduled Commit:\u00a0 X added, Y modified, Z deleted.<\/code><\/li>\n<\/ul>\n<h2>Limitations<\/h2>\n<ul data-spread=\"false\">\n<li><strong>SSMS must remain open and connected<\/strong> to the SQL\u00a0Server instance when the schedule triggers.<\/li>\n<li>VersionSQL checks schedules every 5 minutes, so the actual execution time may vary by up to that amount from the schedule.<\/li>\n<\/ul>\n<h2>Disabling or changing a schedule<\/h2>\n<ul>\n<li>Return to <strong>Advanced\u202fOptions\u00a0\u25b8\u202fSchedule<\/strong>, clear the checkbox, or adjust the time\/days as needed.<\/li>\n<\/ul>\n","protected":false},"author":1,"featured_media":0,"parent":98,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"doc_tag":[],"class_list":["post-1735","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/comments?post=1735"}],"version-history":[{"count":5,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1735\/revisions"}],"predecessor-version":[{"id":1742,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1735\/revisions\/1742"}],"up":[{"embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/98"}],"next":[{"title":"Commit Entire Instance","link":"https:\/\/www.versionsql.com\/help\/documentation\/features\/commit-entire-instance\/","href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1225"}],"wp:attachment":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/media?parent=1735"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/doc_tag?post=1735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}