{"id":4636,"date":"2020-05-19T15:00:16","date_gmt":"2020-05-19T13:00:16","guid":{"rendered":"https:\/\/www.sysfinpro.co.za\/?p=4636"},"modified":"2021-06-10T08:28:07","modified_gmt":"2021-06-10T06:28:07","slug":"kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes","status":"publish","type":"post","link":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/","title":{"rendered":"KB20200519\/01: Sage X3 Tip &#038; Trick &#8211; How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\"><strong>Prerequisites:<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>SQL Server Agent Service must be running at all times<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;SMTP Relay account needs to be setup on the SQL Server<\/li><\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"has-text-align-left wp-block-heading\"><strong>Step 1: Create new SQL Server Job<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>General Tab Name the Task etc. \u201cAccouting Tasks not running\u201d<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Category: Data Collector<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Add description<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Ensure the Job is enabled<\/li><\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png\" alt=\"\" class=\"wp-image-4639\" width=\"644\" height=\"581\" srcset=\"https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-1.png 859w, https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-1-300x270.png 300w, https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-1-768x692.png 768w\" sizes=\"auto, (max-width: 644px) 100vw, 644px\" \/><\/figure><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"has-text-align-left wp-block-heading\"><strong>Step 2: Create the Email Step<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Input the Step name etc. Email<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Type: Transact-SQL script (T-SQL)<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Leave the Database on master then just the declared db in the \u2018Command\u2019<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>In the Command box input like below, update the Database and Shema name<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Replace everything highlighted in Red (the @profile_name will be your Database mail profile)<\/li><\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-2-1.png\" alt=\"\" class=\"wp-image-4648\" width=\"512\" height=\"312\" srcset=\"https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-2-1.png 683w, https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-2-1-300x183.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-3-1.png\" alt=\"\" class=\"wp-image-4649\" width=\"641\" height=\"578\" srcset=\"https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-3-1.png 854w, https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-3-1-300x271.png 300w, https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-3-1-768x693.png 768w\" sizes=\"auto, (max-width: 641px) 100vw, 641px\" \/><\/figure><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"has-text-align-left wp-block-heading\"><strong>Step 3: Adding the Schedule<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Set the Frequency to Daily and set Recurs to 1<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Then set Occurs to any amount of time you wish to check<\/li><\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-4.png\" alt=\"\" class=\"wp-image-4650\" width=\"619\" height=\"546\" srcset=\"https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-4.png 825w, https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-4-300x265.png 300w, https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-4-768x678.png 768w\" sizes=\"auto, (max-width: 619px) 100vw, 619px\" \/><\/figure><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Once done just press Ok and Ok again in order to Save the Job<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>You will see the new Job has been added to the SQL Server Agent<\/li><\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-5.png\" alt=\"\" class=\"wp-image-4651\" width=\"337\" height=\"72\" srcset=\"https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-5.png 337w, https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/SQL-5-300x64.png 300w\" sizes=\"auto, (max-width: 337px) 100vw, 337px\" \/><\/figure><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"has-text-align-left wp-block-heading\"><strong>For further information please email&nbsp;<a href=\"mailto:info@sysfinpro.co.za\">info@sysfinpro.co.za<\/a>&nbsp;or call us on +27 12 880 0258&nbsp;<\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"<p>Prerequisites: SQL Server Agent Service must be running at all times &nbsp;SMTP Relay account needs to be setup on the SQL Server Step 1: Create new SQL Server Job General Tab Name the Task etc. \u201cAccouting Tasks not running\u201d Category: Data Collector Add description Ensure the Job is enabled Step 2: Create the Email Step [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"qubely_global_settings":"","qubely_interactions":"","footnotes":""},"categories":[51,54],"tags":[],"class_list":["post-4636","post","type-post","status-publish","format-standard","hentry","category-erp","category-x3"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"qubely_featured_image_url":null,"qubely_author":{"display_name":"SysFinPro","author_link":"https:\/\/www.sysfinpro.com\/index.php\/author\/sysfinpro\/"},"qubely_comment":0,"qubely_category":"<a href=\"https:\/\/www.sysfinpro.com\/index.php\/category\/erp\/\" rel=\"category tag\">ERP<\/a> <a href=\"https:\/\/www.sysfinpro.com\/index.php\/category\/erp\/x3\/\" rel=\"category tag\">Sage X3<\/a>","qubely_excerpt":"Prerequisites: SQL Server Agent Service must be running at all times &nbsp;SMTP Relay account needs to be setup on the SQL Server Step 1: Create new SQL Server Job General Tab Name the Task etc. \u201cAccouting Tasks not running\u201d Category: Data Collector Add description Ensure the Job is enabled Step 2: Create the Email Step&hellip;","featured_image_urls_v2":{"full":"","thumbnail":"","medium":"","medium_large":"","large":"","1536x1536":"","2048x2048":"","qubely_landscape":"","qubely_portrait":"","qubely_thumbnail":""},"post_excerpt_stackable_v2":"<p>Prerequisites: SQL Server Agent Service must be running at all times &nbsp;SMTP Relay account needs to be setup on the SQL Server Step 1: Create new SQL Server Job General Tab Name the Task etc. \u201cAccouting Tasks not running\u201d Category: Data Collector Add description Ensure the Job is enabled Step 2: Create the Email Step Input the Step name etc. Email Type: Transact-SQL script (T-SQL) Leave the Database on master then just the declared db in the \u2018Command\u2019 In the Command box input like below, update the Database and Shema name Replace everything highlighted in Red (the @profile_name will be&hellip;<\/p>\n","category_list_v2":"<a href=\"https:\/\/www.sysfinpro.com\/index.php\/category\/erp\/\" rel=\"category tag\">ERP<\/a>, <a href=\"https:\/\/www.sysfinpro.com\/index.php\/category\/erp\/x3\/\" rel=\"category tag\">Sage X3<\/a>","author_info_v2":{"name":"SysFinPro","url":"https:\/\/www.sysfinpro.com\/index.php\/author\/sysfinpro\/"},"comments_num_v2":"0 comments","yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB20200519\/01: Sage X3 Tip &amp; Trick - How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes - SysFinPro (Pty) Ltd.<\/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.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB20200519\/01: Sage X3 Tip &amp; Trick - How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes - SysFinPro (Pty) Ltd.\" \/>\n<meta property=\"og:description\" content=\"Prerequisites: SQL Server Agent Service must be running at all times &nbsp;SMTP Relay account needs to be setup on the SQL Server Step 1: Create new SQL Server Job General Tab Name the Task etc. \u201cAccouting Tasks not running\u201d Category: Data Collector Add description Ensure the Job is enabled Step 2: Create the Email Step [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/\" \/>\n<meta property=\"og:site_name\" content=\"SysFinPro (Pty) Ltd.\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-19T13:00:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-10T06:28:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png\" \/>\n<meta name=\"author\" content=\"SysFinPro\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SysFinPro\" \/>\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.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/\"},\"author\":{\"name\":\"SysFinPro\",\"@id\":\"https:\/\/www.sysfinpro.com\/#\/schema\/person\/2e025b2b8c92dacebddf94aae24231bf\"},\"headline\":\"KB20200519\/01: Sage X3 Tip &#038; Trick &#8211; How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes\",\"datePublished\":\"2020-05-19T13:00:16+00:00\",\"dateModified\":\"2021-06-10T06:28:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/\"},\"wordCount\":199,\"publisher\":{\"@id\":\"https:\/\/www.sysfinpro.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png\",\"articleSection\":[\"ERP\",\"Sage X3\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/\",\"url\":\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/\",\"name\":\"KB20200519\/01: Sage X3 Tip & Trick - How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes - SysFinPro (Pty) Ltd.\",\"isPartOf\":{\"@id\":\"https:\/\/www.sysfinpro.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png\",\"datePublished\":\"2020-05-19T13:00:16+00:00\",\"dateModified\":\"2021-06-10T06:28:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#primaryimage\",\"url\":\"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png\",\"contentUrl\":\"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sysfinpro.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB20200519\/01: Sage X3 Tip &#038; Trick &#8211; How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sysfinpro.com\/#website\",\"url\":\"https:\/\/www.sysfinpro.com\/\",\"name\":\"SysFinPro Solutions\",\"description\":\"Sage ERP and Payroll &amp; HR solutions\",\"publisher\":{\"@id\":\"https:\/\/www.sysfinpro.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sysfinpro.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.sysfinpro.com\/#organization\",\"name\":\"SysFinPro\",\"url\":\"https:\/\/www.sysfinpro.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sysfinpro.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/Sysfinpro-logo.png\",\"contentUrl\":\"https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/Sysfinpro-logo.png\",\"width\":427,\"height\":377,\"caption\":\"SysFinPro\"},\"image\":{\"@id\":\"https:\/\/www.sysfinpro.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/9342719\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sysfinpro.com\/#\/schema\/person\/2e025b2b8c92dacebddf94aae24231bf\",\"name\":\"SysFinPro\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sysfinpro.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff7c55c1bd551c2847fc50c01d5475b963bb3dbb9e075fb0332adad88153aaa1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff7c55c1bd551c2847fc50c01d5475b963bb3dbb9e075fb0332adad88153aaa1?s=96&d=mm&r=g\",\"caption\":\"SysFinPro\"},\"sameAs\":[\"https:\/\/www.sysfinpro.co.za\"],\"url\":\"https:\/\/www.sysfinpro.com\/index.php\/author\/sysfinpro\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB20200519\/01: Sage X3 Tip & Trick - How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes - SysFinPro (Pty) Ltd.","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.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/","og_locale":"en_US","og_type":"article","og_title":"KB20200519\/01: Sage X3 Tip & Trick - How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes - SysFinPro (Pty) Ltd.","og_description":"Prerequisites: SQL Server Agent Service must be running at all times &nbsp;SMTP Relay account needs to be setup on the SQL Server Step 1: Create new SQL Server Job General Tab Name the Task etc. \u201cAccouting Tasks not running\u201d Category: Data Collector Add description Ensure the Job is enabled Step 2: Create the Email Step [&hellip;]","og_url":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/","og_site_name":"SysFinPro (Pty) Ltd.","article_published_time":"2020-05-19T13:00:16+00:00","article_modified_time":"2021-06-10T06:28:07+00:00","og_image":[{"url":"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png","type":"","width":"","height":""}],"author":"SysFinPro","twitter_card":"summary_large_image","twitter_misc":{"Written by":"SysFinPro","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#article","isPartOf":{"@id":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/"},"author":{"name":"SysFinPro","@id":"https:\/\/www.sysfinpro.com\/#\/schema\/person\/2e025b2b8c92dacebddf94aae24231bf"},"headline":"KB20200519\/01: Sage X3 Tip &#038; Trick &#8211; How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes","datePublished":"2020-05-19T13:00:16+00:00","dateModified":"2021-06-10T06:28:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/"},"wordCount":199,"publisher":{"@id":"https:\/\/www.sysfinpro.com\/#organization"},"image":{"@id":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png","articleSection":["ERP","Sage X3"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/","url":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/","name":"KB20200519\/01: Sage X3 Tip & Trick - How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes - SysFinPro (Pty) Ltd.","isPartOf":{"@id":"https:\/\/www.sysfinpro.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#primaryimage"},"image":{"@id":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png","datePublished":"2020-05-19T13:00:16+00:00","dateModified":"2021-06-10T06:28:07+00:00","breadcrumb":{"@id":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#primaryimage","url":"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png","contentUrl":"https:\/\/www.sysfinpro.co.za\/wp-content\/uploads\/2020\/05\/SQL-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sysfinpro.com\/index.php\/kb20200519-01-sage-x3-tip-trick-how-to-setup-job-in-microsoft-sql-to-email-recipients-when-journals-have-been-on-hold-for-longer-than-10-minutes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sysfinpro.com\/"},{"@type":"ListItem","position":2,"name":"KB20200519\/01: Sage X3 Tip &#038; Trick &#8211; How To Setup Job In Microsoft SQL to email recipients when journals have been on hold for longer than 10 minutes"}]},{"@type":"WebSite","@id":"https:\/\/www.sysfinpro.com\/#website","url":"https:\/\/www.sysfinpro.com\/","name":"SysFinPro Solutions","description":"Sage ERP and Payroll &amp; HR solutions","publisher":{"@id":"https:\/\/www.sysfinpro.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sysfinpro.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.sysfinpro.com\/#organization","name":"SysFinPro","url":"https:\/\/www.sysfinpro.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sysfinpro.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/Sysfinpro-logo.png","contentUrl":"https:\/\/www.sysfinpro.com\/wp-content\/uploads\/2020\/05\/Sysfinpro-logo.png","width":427,"height":377,"caption":"SysFinPro"},"image":{"@id":"https:\/\/www.sysfinpro.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/9342719"]},{"@type":"Person","@id":"https:\/\/www.sysfinpro.com\/#\/schema\/person\/2e025b2b8c92dacebddf94aae24231bf","name":"SysFinPro","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sysfinpro.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff7c55c1bd551c2847fc50c01d5475b963bb3dbb9e075fb0332adad88153aaa1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff7c55c1bd551c2847fc50c01d5475b963bb3dbb9e075fb0332adad88153aaa1?s=96&d=mm&r=g","caption":"SysFinPro"},"sameAs":["https:\/\/www.sysfinpro.co.za"],"url":"https:\/\/www.sysfinpro.com\/index.php\/author\/sysfinpro\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sysfinpro.com\/index.php\/wp-json\/wp\/v2\/posts\/4636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sysfinpro.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sysfinpro.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sysfinpro.com\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sysfinpro.com\/index.php\/wp-json\/wp\/v2\/comments?post=4636"}],"version-history":[{"count":0,"href":"https:\/\/www.sysfinpro.com\/index.php\/wp-json\/wp\/v2\/posts\/4636\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sysfinpro.com\/index.php\/wp-json\/wp\/v2\/media?parent=4636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sysfinpro.com\/index.php\/wp-json\/wp\/v2\/categories?post=4636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sysfinpro.com\/index.php\/wp-json\/wp\/v2\/tags?post=4636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}