locked
AsyncOperation Table Records deletion between Dates RRS feed

  • Question

  • 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

  • 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
  • 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
  • In 2011 you can look for System Jobs.  Use the filter I described above.


    Jason Peterson

    Wednesday, September 5, 2012 5:02 PM