{"id":11697,"date":"2016-01-14T07:09:22","date_gmt":"2016-01-14T07:09:22","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=11697"},"modified":"2016-01-14T07:09:22","modified_gmt":"2016-01-14T07:09:22","slug":"automatic-closure-of-dormant-leads","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/","title":{"rendered":"Automatic Closure of Dormant Leads"},"content":{"rendered":"

We may want to have Leads that has not been attended for 6 months, to be automatically marked as ‘Closed<\/strong>‘. The easiest way to do this, is to schedule a Job in SQL.
\nNew Stuff:\u00a0<\/em><\/strong><\/span>Add Calendar Gadget in an Interactive Dashboard in Sage CRM<\/a>
\nOne can easily check leads which are 6 months older in Sage CRM by executing below query.
\n\"Image11\"
\n<\/a>Leads can be closed by executing below query manually in SQL.
\n\"Image22\"
\n<\/a>In order to do automation, SQL Job needs to be created. Kindly follow below steps to create SQL Job.
\n1) Start SQL Server Management studio and click on SQL Server Agent node.
\n2) Right click on Jobs to create New Job.
\n\"Image33\"<\/a>
\n3) When you click on New Job, you will get below window. Fill the details as shown in screenshot.
\n\"Image44\"<\/a>
\n4) Select Steps from right hand side and add data as shown below.
\n\"Image55\"<\/a>
\n5) Click on OK button.
\n6) Select Schedules from right hand side and schedule job as per convenience.
\n\"Image66\"<\/a>
\n7) Click on OK button.
\n8) Click on OK button of New Job window.
\nNow, scheduled SQL job will run every day as scheduled in SQL and all leads which are 6 months old in Sage CRM will be marked as closed. You can schedule a similar job for any other entity in Sage CRM like Cases, Communications, Opportunities or any other custom entities.
\nAlso Read:<\/span>
\n<\/em><\/strong>1) Unexpected event on converting Lead to Opportunity in Sage CRM 7.3<\/a>
\n<\/u>2) Adding Documents Tab to Leads in Sage CRM 2014 R2<\/a>
\n<\/u>3) Lead De-duplication nice to have feature in Sage CRM 7.3<\/a>
\n<\/u>4) Lead to Company\/Person Field Mapping<\/a>
\n<\/u>5) Document Management against Lead Entity<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

We may want to have Leads that has not been attended for 6 months, to be automatically marked as ‘Closed‘. The easiest way to do this, is to schedule a Job in SQL. New Stuff:\u00a0Add Calendar Gadget in an Interactive Dashboard in Sage CRM One can easily check leads which are 6 months older in\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83,124,210,332,336,337,338,342,1],"tags":[793,833,1000,1410,1497,2010,2030,2031,2033,2035,2140],"class_list":["post-11697","post","type-post","status-publish","format-standard","hentry","category-crm72","category-dormant","category-lead","category-sage-crm","category-sage-crm-7-1-sp2","category-sage-crm-7-2","category-sage-crm-73","category-sage-crm7-3","category-uncategorized","tag-crm","tag-crm7-0","tag-dormant","tag-inactive","tag-lead","tag-sage-crm","tag-sage-crm-7-0","tag-sage-crm-7-1","tag-sage-crm-7-2","tag-sage-crm-7-3","tag-sage-crm-com"],"yoast_head":"\nAutomatic Closure of Dormant Leads - Sage CRM \u2013 Tips, Tricks and Components<\/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.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automatic Closure of Dormant Leads - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"We may want to have Leads that has not been attended for 6 months, to be automatically marked as ‘Closed‘. The easiest way to do this, is to schedule a Job in SQL. New Stuff:\u00a0Add Calendar Gadget in an Interactive Dashboard in Sage CRM One can easily check leads which are 6 months older in\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-14T07:09:22+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/Image11.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/\",\"name\":\"Automatic Closure of Dormant Leads - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/Image11.jpg\",\"datePublished\":\"2016-01-14T07:09:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/Image11.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/Image11.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automatic Closure of Dormant Leads\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Automatic Closure of Dormant Leads - Sage CRM \u2013 Tips, Tricks and Components","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.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/","og_locale":"en_US","og_type":"article","og_title":"Automatic Closure of Dormant Leads - Sage CRM \u2013 Tips, Tricks and Components","og_description":"We may want to have Leads that has not been attended for 6 months, to be automatically marked as ‘Closed‘. The easiest way to do this, is to schedule a Job in SQL. New Stuff:\u00a0Add Calendar Gadget in an Interactive Dashboard in Sage CRM One can easily check leads which are 6 months older in\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2016-01-14T07:09:22+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/Image11.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/","name":"Automatic Closure of Dormant Leads - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/Image11.jpg","datePublished":"2016-01-14T07:09:22+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/Image11.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2016\/01\/Image11.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2016\/01\/14\/automatic-closure-of-dormant-leads\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Automatic Closure of Dormant Leads"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=11697"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11697\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=11697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=11697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=11697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}