{"id":1051,"date":"2020-11-13T15:34:23","date_gmt":"2020-11-13T07:34:23","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1051"},"modified":"2020-11-20T09:11:25","modified_gmt":"2020-11-20T01:11:25","slug":"setting-up-a-sql-image-viewer-export-task-in-windows-task-scheduler","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/11\/13\/setting-up-a-sql-image-viewer-export-task-in-windows-task-scheduler\/","title":{"rendered":"Setting up a SQL Image Viewer export task in Windows Task Scheduler"},"content":{"rendered":"

SQL Image Viewer<\/a> Professional Edition allows you to save your export tasks and run them unattended using the SQL Image Viewer command line interface.\u00a0 This blog describes how to set up a Windows Task Scheduler recurring task to run SQL Image Viewer export tasks.<\/p>\n

You must first set up and save an export settings file using the SQL Image Viewer GUI, described here<\/a>.\u00a0 \u00a0Before setting up the export task in Task Scheduler, we should make sure that the export task can be ran successfully from the command prompt.<\/p>\n

To do that, open a command prompt window and navigate to the folder where the SQL Image Viewer<\/a> command line interface executable file (SQLImageViewerCmd.exe) is located.<\/p>\n

\"\"<\/p>\n

Enter the command line interface file name, and provide the fully qualified export settings file name as the first parameter.\u00a0 You must enclose the parameter in double quotes if it contains spaces.<\/p>\n

\"\"<\/p>\n

Run the command and check that the export task ran successfully.<\/p>\n

\"\"<\/p>\n

Now we can start up the Task Scheduler.\u00a0 We will create a basic task in this example.<\/p>\n

\"\"<\/p>\n

Enter a name and description for the task.<\/p>\n

\"\"<\/p>\n

Select your required frequency to run the task, and the frequency settings on the subsequent page.<\/p>\n

\"\"<\/p>\n

Select the Start a program<\/strong> action.<\/p>\n

\"\"<\/p>\n

In the program settings window, enter the fully qualified file name<\/span> to SQLImageViewerCmd.exe, enclosed in double quotes.\u00a0 For the arguments, enter the fully qualified file name<\/span> to the export settings file, enclosed in double quotes.\u00a0 For the Start in<\/strong> value, enter the fully qualified folder name<\/span> of the folder where SQLImageViewerCmd.exe is located, without<\/strong> the double quotes.<\/p>\n

\"\"<\/p>\n

And you’re done.<\/p>\n

\"\"<\/p>\n

You can run the task to check if everything has been set up correctly.<\/p>\n

\"\"<\/p>\n

A log file is automatically created every time the SQL Image Viewer command line interface runs.\u00a0 The folder where the logs are stored is displayed in the GUI:<\/p>\n

\"\"<\/p>\n

You would inspect the log files if your export task no longer runs successfully.<\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

SQL Image Viewer Professional Edition allows you to save your export tasks and run them unattended using the SQL Image Viewer command line interface.\u00a0 This blog describes how to set up a Windows Task Scheduler recurring task to run SQL Image Viewer export tasks. You must first set up and save an export settings file […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[11],"tags":[12],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1051"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=1051"}],"version-history":[{"count":3,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1051\/revisions"}],"predecessor-version":[{"id":1066,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1051\/revisions\/1066"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1051"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1051"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}