Codeunit to optimize some table daily with schedule

hhhhhhhqat

any codeunit to optimize the tables , run automatically with schedule , we can select some tables and run this code ??

Savatage

you mean like this?
viewtopic.php?f=5&t=10331

hhhhhhhqat

thanks for your reply , but i need to be Report or codeunit to run by Scheduler .

i want to optimize day night

thanks

matttrax

Savatage wrote:

you mean like this?
viewtopic.php?f=5&t=10331

hhhhhhhqat wrote:

but i need to be Report or codeunit

So write a Report or Codeunit based on that code

hhhhhhhqat

please , can you explain more .

stryk

Are you running a native C/SIDE Server or SQL Server?

stryk

hhhhhhhqat wrote:

please , can you explain more .

I guess he means this:
The link refers to a post which actually shows the solution (using "Win Scripting Host" and "Send Key" method). All you need to do is to move the Form based code into a Report or Codeunit - which is not that difficult :twisted:

hhhhhhhqat

i have some database using Native and the main server is SQL
ur near the solution , if this form is running, how we can convert to report or codeunit ?

stryk

hhhhhhhqat wrote:

i have some database using Native and the main server is SQL

Uh ... I'm not sure what that should mean ... it's either native or SQL, definitely not a mix of both ... :shock:
If you are running SQL Server then you shouldn't use the "Table Optimizer" anyway - there are much better ways to accomplish this on SQL Server site using "Maintenance Plans" or some procedures ...

hhhhhhhqat wrote:

ur near the solution , if this form is running, how we can convert to report or codeunit ?

I'm afraid you are lacking essential basic skills in NAV programming, so I strongly recommend to not fiddle with "Table Optimizer" etc. without support of your Dynamics NAV partner ... :-k

hhhhhhhqat

closed