A way to handle maintenance on machines in Microsoft Dynamics NAV is to create production orders with operations that represent the maintenance. The beauty of this is that you can then include the maintenance when scheduling the production orders, you also maintain history about when the maintenance was done and you have the option to capture the labor cost related to maintenance.
Tag Archives: Maintenance
SQL Maintenance Plan with Database Mail
As discussed in last two post about
1) How to Configure Database Mail in SQL Server.
2) How to create operator in SQL?
Let’s see the uses of last post in this post, by creating a simple maintenance plan for taking automatic Backup from SQL and Notifying the administrator about success or failure of the Job performed by Maintenance Plan.
NAV on SQL – Essential Maintenance
This video shows you how to set up essential maintenance for Microsoft Dynamics NAV databases on SQL Server. Sorry about the audio, I didn’t notice it wasn’t picking up my headset until after I finished the recording.
NAV on SQL – Essential Maintenance
This video shows you how to set up essential maintenance for Microsoft Dynamics NAV databases on SQL Server.
SQL Maintenance from Dynamics NAV
When running Dynamics NAV on a MS-SQL database you need to execute some maintenance tasks. They include defrag and rebuild for indexes and statistics update.