{"id":73,"date":"2024-03-27T05:04:19","date_gmt":"2024-03-27T05:04:19","guid":{"rendered":"https:\/\/docs.sqlbackupandftp.com\/docs\/how-it-works\/backup-job\/scheduler\/"},"modified":"2024-07-09T20:10:20","modified_gmt":"2024-07-09T20:10:20","slug":"scheduler","status":"publish","type":"docs","link":"http:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/","title":{"rendered":"Scheduler"},"content":{"rendered":"<p>To set a schedule for a backup job enable the <strong>Schedule backups<\/strong> option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-433\" src=\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups.png\" alt=\"\" width=\"635\" height=\"374\" srcset=\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups.png 635w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups-300x177.png 300w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups-230x135.png 230w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups-350x206.png 350w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups-480x283.png 480w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><\/p>\n<p>SQLBackupAndFTP allows you to perform the following types of backups:<\/p>\n<ul>\n<li>Full, differential, and transaction log backups for Microsoft SQL Server (local)<\/li>\n<li>Full and incremental backups for MySQL Server (TCP\/IP) with a local connection<\/li>\n<li>Full backups for all other DBMS connections<\/li>\n<\/ul>\n<p>Click on the gear icon to find the advanced schedule settings.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-434\" src=\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups-info-button.png\" alt=\"\" width=\"627\" height=\"146\" srcset=\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups-info-button.png 627w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups-info-button-300x70.png 300w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups-info-button-230x54.png 230w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups-info-button-350x81.png 350w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups-info-button-480x112.png 480w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/p>\n<p>In the opened window, you can set the following:<\/p>\n<ul>\n<li>Backup types to be performed and their corresponding time intervals<\/li>\n<li>&#8220;Run between&#8221; option to specify a time interval for performing backups<\/li>\n<li>Days when a backup job should be run (both specific days of the week and ordinal numbers for days in a month can be specified)<\/li>\n<li>Date and time for the first backup. Note: if the &#8220;Run between&#8221; option is enabled, ensure that the first backup falls within the specified time interval.<\/li>\n<\/ul>\n<p>In the &#8220;Estimate backup plan&#8221; section, you can view the schedule of when the backups will be executed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-438\" src=\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Advanced-Backup-Schedule.png\" alt=\"\" width=\"853\" height=\"643\" srcset=\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Advanced-Backup-Schedule.png 853w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Advanced-Backup-Schedule-300x226.png 300w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Advanced-Backup-Schedule-768x579.png 768w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Advanced-Backup-Schedule-230x173.png 230w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Advanced-Backup-Schedule-350x264.png 350w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Advanced-Backup-Schedule-480x362.png 480w\" sizes=\"(max-width: 853px) 100vw, 853px\" \/><\/p>\n<p>By clicking the <strong>Load a typical backup plan<\/strong> link, you can select one of the five pre-established backup plans.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-439\" src=\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Load-a-typical-backup-plan.png\" alt=\"\" width=\"577\" height=\"317\" srcset=\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Load-a-typical-backup-plan.png 577w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Load-a-typical-backup-plan-300x165.png 300w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Load-a-typical-backup-plan-230x126.png 230w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Load-a-typical-backup-plan-350x192.png 350w, http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Load-a-typical-backup-plan-480x264.png 480w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/p>\n","protected":false},"featured_media":0,"parent":67,"menu_order":3,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-73","docs","type-docs","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Scheduler - SQLBackupAndFTP Documentation<\/title>\n<meta name=\"description\" content=\"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Scheduler - SQLBackupAndFTP Documentation\" \/>\n<meta property=\"og:description\" content=\"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/\" \/>\n<meta property=\"og:site_name\" content=\"SQLBackupAndFTP Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-09T20:10:20+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/\",\"url\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/\",\"name\":\"Scheduler - SQLBackupAndFTP Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups.png\",\"datePublished\":\"2024-03-27T05:04:19+00:00\",\"dateModified\":\"2024-07-09T20:10:20+00:00\",\"description\":\"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/#primaryimage\",\"url\":\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups.png\",\"contentUrl\":\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups.png\",\"width\":635,\"height\":374},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.sqlbackupandftp.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Job Settings\",\"item\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Backup Job\",\"item\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Scheduler\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/#website\",\"url\":\"https:\/\/docs.sqlbackupandftp.com\/\",\"name\":\"SQLBackupAndFTP Documentation\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.sqlbackupandftp.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/#organization\",\"name\":\"pranas.net\",\"url\":\"https:\/\/docs.sqlbackupandftp.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/04\/SbfLogo80.png\",\"contentUrl\":\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/04\/SbfLogo80.png\",\"width\":80,\"height\":80,\"caption\":\"pranas.net\"},\"image\":{\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Scheduler - SQLBackupAndFTP Documentation","description":"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/","og_locale":"en_US","og_type":"article","og_title":"Scheduler - SQLBackupAndFTP Documentation","og_description":"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.","og_url":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/","og_site_name":"SQLBackupAndFTP Documentation","article_modified_time":"2024-07-09T20:10:20+00:00","og_image":[{"url":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/","url":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/","name":"Scheduler - SQLBackupAndFTP Documentation","isPartOf":{"@id":"https:\/\/docs.sqlbackupandftp.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/#primaryimage"},"image":{"@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/#primaryimage"},"thumbnailUrl":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups.png","datePublished":"2024-03-27T05:04:19+00:00","dateModified":"2024-07-09T20:10:20+00:00","description":"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.","breadcrumb":{"@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/#primaryimage","url":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups.png","contentUrl":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-Schedule-backups.png","width":635,"height":374},{"@type":"BreadcrumbList","@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/scheduler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.sqlbackupandftp.com\/"},{"@type":"ListItem","position":2,"name":"Job Settings","item":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/"},{"@type":"ListItem","position":3,"name":"Backup Job","item":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/"},{"@type":"ListItem","position":4,"name":"Scheduler"}]},{"@type":"WebSite","@id":"https:\/\/docs.sqlbackupandftp.com\/#website","url":"https:\/\/docs.sqlbackupandftp.com\/","name":"SQLBackupAndFTP Documentation","description":"","publisher":{"@id":"https:\/\/docs.sqlbackupandftp.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.sqlbackupandftp.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.sqlbackupandftp.com\/#organization","name":"pranas.net","url":"https:\/\/docs.sqlbackupandftp.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.sqlbackupandftp.com\/#\/schema\/logo\/image\/","url":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/04\/SbfLogo80.png","contentUrl":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/04\/SbfLogo80.png","width":80,"height":80,"caption":"pranas.net"},"image":{"@id":"https:\/\/docs.sqlbackupandftp.com\/#\/schema\/logo\/image\/"}}]}},"comment_count":0,"_links":{"self":[{"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs\/73"}],"collection":[{"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/comments?post=73"}],"version-history":[{"count":7,"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs\/73\/revisions"}],"predecessor-version":[{"id":1295,"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs\/73\/revisions\/1295"}],"up":[{"embeddable":true,"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs\/67"}],"next":[{"title":"Email Notifications","link":"http:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/email-notifications\/","href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs\/74"}],"prev":[{"title":"Destinations","link":"http:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/destinations\/","href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs\/542"}],"wp:attachment":[{"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/media?parent=73"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/doc_tag?post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}