none
Using Windows Task Scheduler To Call and Run an ASC Sequel (HelpSystems) Query Script RRS feed

  • Question

  • I've recently switched to MS Office 365 64 bit in order to take advantage of the additional ram in my computer. The main drawback is that, where before, in Office 2010 64 bit, I could use VBA to call ASC Sequel queries from within Office apps, Office 365 64 bit does not play well, or at all, with this method.  I've learned how to set up scripts in ASC Sequel to run my queries and save the output as csv files that I can link my spreadsheets to.  The catch is, I have 15 - 20 different queries I run every day.  I need a way to schedule these to run during the early morning hours so the data is available for me to use as soon as I arrive.  Below is one of the scripts that I have set up to run two different queries from my work computer, connected to our network.  This script does exactly what I want it to, as long as I open ASC Sequel and run it manually.  I've tried using the "Schedule" option in ASC Sequel, but something causes it to blow up.  Our IT department is either mystified or not interested, not sure which.  If I could use Task Scheduler to "manually" call and run the script, it should work.  Any help would be appreciated.

    
    VPSHELL CMD('"C:\Program Files (x86)\SEQUEL ViewPoint\ViewPnt.exe" /V:ASCSEQUEL.MOHAWKIND.COM/ASCPWRUSR/AR_BKGHSCM /D:\\michg03\users\YARN PLANNING\JRA\QUERY OUT\AR_BKGHSCM.csv /Q:N'

    VPSHELL CMD('"C:\Program Files (x86)\SEQUEL ViewPoint\ViewPnt.exe" /V:ASCSEQUEL.MOHAWKIND.COM/ASCPWRUSR/AR_BKGHS12 /D:\\michg03\users\YARN PLANNING\JRA\QUERY OUT\AR_BKGHS12.csv /Q:N'

    Thanks,

    Randy A.

    • Moved by Bill_Stewart Friday, August 14, 2015 8:02 PM This is not a support forum for third-party software
    Friday, July 10, 2015 2:41 PM

All replies

  • Sorry but this is not a VBA forum.  VBA is not a scripting language.  Post int he VBA forum for Office.  For issues with third party tools post in the vendors forums.


    \_(ツ)_/

    • Proposed as answer by Mike Laughlin Friday, July 10, 2015 3:02 PM
    Friday, July 10, 2015 2:55 PM