{"id":42,"date":"2012-11-23T08:14:07","date_gmt":"2012-11-23T14:14:07","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2012\/11\/changes-to-periodic-triggers\/"},"modified":"2015-10-26T11:54:55","modified_gmt":"2015-10-26T16:54:55","slug":"changes-to-periodic-triggers","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/","title":{"rendered":"Changes to periodic triggers"},"content":{"rendered":"<p>For a long time periodic triggers where processed at midnight on a daily basis; monthly triggers were processed on a 1st of month. If you wanted to change this behavior you were needed to use a workaround: a time-dependent trigger based on a formula the calculates desired date and time based on a current date\/time obtained via Today() or Now() functions.<\/p>\n<p>This workaround is no longer needed. Today, <a href=\"http:\/\/www.teamdesk.net\">TeamDesk<\/a>\u2019s periodic triggers were extended with two options \u2013 a time to process the trigger (midnight is still the default) and, for monthly trigger case, the day of the month.<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2012\/11\/291.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-388\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2012\/11\/291.png\" alt=\"29,1\" width=\"349\" height=\"62\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2012\/11\/291.png 349w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2012\/11\/291-300x53.png 300w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><\/a><\/p>\n<p>Moreover, time-dependent trigger approach for the problem is quite ineffective. Let\u2019s see how triggers work.<\/p>\n<p>The periodic trigger runs once a day\/month at specified time. In contrast, time-dependent trigger gets filtered list of records, calculates the date\/timestamp column for every record and then checks what records it should process and does it every 3 minutes or so.<\/p>\n<p>In case of workaround, the column the trigger is based on is typically a formula that uses Today()\/Now() and adds or subtracts an offset. It calculates to exactly the same value for every record filtered by the trigger and in most cases the application is wasting the time and resources just to find out there is nothing to process.<\/p>\n<p>So, if you are using time-dependent workarounds, we kindly ask you to convert them to periodic triggers. To find such triggers quickly we have extended Performance Tips page found under Setup tab, Tools section to report <em>Nondeterministic Time-Dependent Triggers<\/em>. If you are in doubt, do not hesitate to ask for help at <a href=\"mailto:support@teamdesk.net\">support@teamdesk.net<\/a>.<\/p>\n<p>And, by the way, view subscriptions were extended with the same set of options.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For a long time periodic triggers where processed at midnight on a daily basis; monthly triggers were processed on a 1st of month. If you wanted to change this behavior you were needed to use a workaround: a time-dependent trigger based on a formula the calculates desired date and time based on a current date\/time [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-42","post","type-post","status-publish","format-standard","hentry","category-whats-new"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Changes to periodic triggers - TeamDesk Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Changes to periodic triggers - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"For a long time periodic triggers where processed at midnight on a daily basis; monthly triggers were processed on a 1st of month. If you wanted to change this behavior you were needed to use a workaround: a time-dependent trigger based on a formula the calculates desired date and time based on a current date\/time [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-23T14:14:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-10-26T16:54:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2012\/11\/291.png\" \/>\n<meta name=\"author\" content=\"Kirill Bondar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirill Bondar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/\"},\"author\":{\"name\":\"Kirill Bondar\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"headline\":\"Changes to periodic triggers\",\"datePublished\":\"2012-11-23T14:14:07+00:00\",\"dateModified\":\"2015-10-26T16:54:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/\"},\"wordCount\":291,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/11\\\/291.png\",\"articleSection\":[\"What's New\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/\",\"name\":\"Changes to periodic triggers - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/11\\\/291.png\",\"datePublished\":\"2012-11-23T14:14:07+00:00\",\"dateModified\":\"2015-10-26T16:54:55+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/11\\\/291.png\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/11\\\/291.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/changes-to-periodic-triggers\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Changes to periodic triggers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\",\"name\":\"Kirill Bondar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"caption\":\"Kirill Bondar\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/kirill-bondar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Changes to periodic triggers - TeamDesk Blog","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:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/","og_locale":"en_US","og_type":"article","og_title":"Changes to periodic triggers - TeamDesk Blog","og_description":"For a long time periodic triggers where processed at midnight on a daily basis; monthly triggers were processed on a 1st of month. If you wanted to change this behavior you were needed to use a workaround: a time-dependent trigger based on a formula the calculates desired date and time based on a current date\/time [&hellip;]","og_url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/","og_site_name":"TeamDesk Blog","article_published_time":"2012-11-23T14:14:07+00:00","article_modified_time":"2015-10-26T16:54:55+00:00","og_image":[{"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2012\/11\/291.png","type":"","width":"","height":""}],"author":"Kirill Bondar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirill Bondar","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/"},"author":{"name":"Kirill Bondar","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"headline":"Changes to periodic triggers","datePublished":"2012-11-23T14:14:07+00:00","dateModified":"2015-10-26T16:54:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/"},"wordCount":291,"commentCount":1,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2012\/11\/291.png","articleSection":["What's New"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/","url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/","name":"Changes to periodic triggers - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2012\/11\/291.png","datePublished":"2012-11-23T14:14:07+00:00","dateModified":"2015-10-26T16:54:55+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2012\/11\/291.png","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2012\/11\/291.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/changes-to-periodic-triggers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Changes to periodic triggers"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2","name":"Kirill Bondar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","caption":"Kirill Bondar"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/kirill-bondar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=42"}],"version-history":[{"count":2,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/42\/revisions"}],"predecessor-version":[{"id":390,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/42\/revisions\/390"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=42"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=42"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}