How to run the INVOICES database maintenance plan from a command line
An INVOICES database maintenance plan can be run from a command prompt by calling eimngr.exe with the /M switch and the name of the maintenance plan.
For example, if INVOICES is installed in the default location, and a maintenance plan named REPAIR_DB has been created, the command will appear as follows:
"C:\Program Files (x86)\ReadSoft\INVOICES\Bin\eimngr.exe" /M REPAIR_DB
Note: The quotation marks around the path are required since the path contains spaces.
Maintenance plans can also be set up to run automatically. This allows the plan to run after hours in order to minimize the impact to users. The process is the same as above, simply configure a Scheduled Task with the command line as described.
Automatic plans are set up through the Windows Task Scheduler, which can be accessed two ways:
- From a command prompt, type Taskschd.msc.
- From the Windows Start menu, click Control Panel, click System and Maintenance, click Administrative Tools, and then double-click Task Scheduler.
Within Task Scheduler, create a new task to run the eimngr.exe program at the desired date and time. For instructions on using Task Scheduler, see the Microsoft article Schedule a task.
Note: If database objects are locked, the maintenance plan will not run. In this event, unlock the database objects through the Administration menu in the INVOICES Manager module or set the parameter AllowMaintenanceOnLockedObjects to a value of 1 (one).
Keywords: maintenance, database