Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Where are system jobs ...
Customer experience | Sales, Customer Insights,...
Answered

Where are system jobs (waiting status) stored in the CRM 29016 database

(0) ShareShare
ReportReport
Posted on by nickmangioros 460

Hi,

Where are system jobs (waiting status) stored in the CRM 29016 database.

Thanks

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: Where are system jobs (waiting status) stored in the CRM 29016 database

    Hi,

    You can delete from advanced find as well and filter by the workflow  name associated with case entity.

    cloudblogs.microsoft.com/.../

  • Suggested answer
    ajyendra Profile Picture
    ajyendra 1,730 on at
    RE: Where are system jobs (waiting status) stored in the CRM 29016 database

    Yes , you can delete these jobs directly from table and for case entity I think you have to check condition for primaryentitytype

  • nickmangioros Profile Picture
    nickmangioros 460 on at
    RE: Where are system jobs (waiting status) stored in the CRM 29016 database

    additional information

    Want the ones deleted related to the Case Entity only

    Thanks

  • nickmangioros Profile Picture
    nickmangioros 460 on at
    RE: Where are system jobs (waiting status) stored in the CRM 29016 database

    Is it safe to delete these jobs directly in the table?

  • Suggested answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: Where are system jobs (waiting status) stored in the CRM 29016 database

    Hi..

    from database you can get Waiting jobs using

    select * from AsyncOperation where StatusCode =10

    this query.

  • nickmangioros Profile Picture
    nickmangioros 460 on at
    RE: Where are system jobs (waiting status) stored in the CRM 29016 database

    Thanks,

    Can I deleted all waiting system jobs as there are quite a few that have been backlogged and do not what them to go to customers.

    I cannot do it from Bulk delete as that only deletes cancelled system jobs

    thanks for your help.

  • Verified answer
    David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: Where are system jobs (waiting status) stored in the CRM 29016 database

    These are in the asyncoperation entity (AsyncOperationBase table in SQL)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans