Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
AsyncOperation Table Records deletion between Dates RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    I would like to delete system jobs for year 2010 and 2009 as DB is growing up.

    Can anyone please suggest how to delete AsyncOperation Table Records between Dates.

    Thanks in Advances

    Regards

    RVB

    Rudravarma Batta

    Thursday, August 30, 2012 10:57 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    In CRM 2011, you can create your own bulk delete jobs from the UI.  Settings -> System -> Data Management -> Bulk Record Deletion.  Click New.

    Create a filter Look for: System Jobs, Completed On - On or Before - 12/31/2010 and step through the rest of the wizard.  You don't need to set it recurring.

    For CRM 4 you could look on codeplex and see if you can download a bulk delete tool.

    I would recomend making a backup of the org database before doing any deletion.  In 4.0 there were recurring system jobs would have to be rebuilt through SDK if they were deleted.  So be careful what you delete.

    Jason Peterson

    Thursday, August 30, 2012 11:34 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jason,

    Thanks for your reply.

    But there is not possiblility to create a filter Look for: System Jobs right?

    Can you please tell me how to move on with this?

    Thanks

    RVB

    Rudravarma Batta

    Friday, August 31, 2012 10:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    In 2011 you can look for System Jobs.  Use the filter I described above.

    Jason Peterson

    Wednesday, September 5, 2012 5:02 PM