ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon SQL Backup Options
DrillDown Icon Setup the OLE DB(ADO) for SQL Crystal Reports
DrillDown Icon APIs
DrillDown Icon Code that could be used to find Last Table Modified within SQL
DrillDown Icon Configure SQL Server 2008 R2 to allow Network Connections
DrillDown Icon How to detach and attached databases using the SQL Server Management Studio
DrillDown Icon Restore SQL DB from Backup
DrillDown Icon Setup a SQL Test/Sandbox Database
DrillDown Icon SQLManex Client Server Setup Instructions
DrillDown Icon Setup Folder Permissions to Write "ini" File
DrillDown Icon Setup the ODBC for SQL Crystal Reports
DrillDown Icon Setup a SQL Database Maintenance Plan
DrillDown Icon Setup Task Scheduler to Auto Run MRP
DrillDown Icon Selecting the Authentication Mode
DrillDown Icon Window 10 - Network Disconnect
DrillDown Icon Setup Work Stations
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Setup Task Scheduler to Auto Run MRP

Prerequisite:   Although the "sqlautomrprun" executable should already be located in the Main SQL Manex application directory on server. You can download the sqlautomrprun.exe from the CRM into the Main SQLManex directory. 

Go to Control Panel/System and Security/Administrative Tools/Task Scheduler 




Select to Create Basic Task



Enter a Name and Description 



Depress NEXT and Select How Often to Run (Daily, Weekly, Monthly, etc . . .)



Depress NEXT and Select Specific Time to Run



Depress NEXT and Select Action (In this case select Start a Program)



Depress NEXT and Select the SQLautomrprun.exe found in directory. Note even though says optional you must put in the Start in directory where the .exe is located for it to recognize the .ini file needed to log into SQL server.



Depress NEXT and Verify Settings




Select Finish if everything is correct. 

NOTE:  There are other settings users can choose, but will leave it up to the user to decide what additional setting they want to setup.

1.     






Article ID: 5674