Re: [Axapta-Knowledge-Village] Setting Reindexing as a batch process

2008-05-19 Thread Sumit Loya 
Hi,

I have a small code with which you can create a batch class and schedule it
for batch run.

Below is the piece of code:

*SqlDataDictionary sqlDict = new SqlDataDictionary();
;*
*new SqlDataDictionaryPermission(methodstr(SqlDataDictionary,
tableReindex)).assert();
sqlDict.tableReindex();
CodeAccessPermission::revertAssert();*
Ensure  that you run the code on server otherwise the
SqlDataDictionaryPermission will fail.

Hope this is of some help to you.

Regards,
Sumit
On Sat, May 17, 2008 at 9:02 AM, Satish [EMAIL PROTECTED] wrote:

   Hi All,

 Would appreciate any pointers to setup reindexing (Administration |
 Periodic | SQL Administration | Index Actions  Reindex) as a batch
 process in AX?

 Also what would be a optimal schedule for reindexing the tables? I was
 thinking of a daily reindex of all the tables.

 Looking forward to any views, comments, pointers...

 Thanks,
 Satish

Re: [Axapta-Knowledge-Village] Setting Reindexing as a batch process

2008-05-19 Thread Varden Morris 
I believe it's better to have the DBA include this in the MSSQL maintenance 
plan.
 
Varden Morris 

276 Taralake Terrace N.E. 
Calgary, Alberta T3J 0A1 
Canada 

(403) 366-8434 (H) 
(403) 615-1604 (C)
[EMAIL PROTECTED]
 
 



- Original Message 
From: Sumit Loya [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Monday, May 19, 2008 1:47:10 AM
Subject: Re: [Axapta-Knowledge-Village] Setting Reindexing as a batch process


Hi,
 
I have a small code with which you can create a batch class and schedule it for 
batch run.
 
Below is the piece of code:
 
    SqlDataDictionary sqlDict = new SqlDataDictionary( );
    ;
    new SqlDataDictionaryPe rmission( methodstr( SqlDataDictionar y, 
tableReindex) ).assert( );
    sqlDict.tableReinde x();
    CodeAccessPermissio n::revertAssert( );

Ensure  that you run the code on server otherwise the SqlDataDictionaryPe 
rmission will fail.
 
Hope this is of some help to you.
 
Regards,
Sumit

On Sat, May 17, 2008 at 9:02 AM, Satish satishdalal@ gmail.com wrote:

Hi All,

Would appreciate any pointers to setup reindexing (Administration | 
Periodic | SQL Administration | Index Actions  Reindex) as a batch 
process in AX? 

Also what would be a optimal schedule for reindexing the tables? I was 
thinking of a daily reindex of all the tables.

Looking forward to any views, comments, pointers...

Thanks,
Satish