navision 2009 r2 jobs

hi We scheduled one job in Navision 2009.if the number of records to process is same also it will take different times to complete. sometimes very long time.
Somedays we notice even if large amount of data also it will complete within fewseconds but sometime if less also it will take long time to complete.We findout Table lock as one reason .Sometimes if table lock is not there also it will take time.Kindly someone suggest

Answers

  • allenyyzhouallenyyzhou Member Posts: 142
    Hi, Renu1989

    Besides table lock, sometimes because the server are running other processes, like other process in NAV, or DB backup. You can use following sql to check what is running in SQL server when it takes time to run your jobs. But if you are using fdb not sql db, i am not sure how to check that, sorry.

    SELECT sqltext.TEXT,
    req.session_id,
    req.status,
    req.command,
    req.cpu_time,
    req.total_elapsed_time
    FROM sys.dm_exec_requests req
    CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

  • David_SingletonDavid_Singleton Member Posts: 5,479
    Can you post some details about your system, size, no of users server configuration etc.
    David Singleton
Sign In or Register to comment.