cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
D365Ideas_Admin

SQL Jobs Bug

Submitted by D365Ideas_Admin on โ€Ž02-04-2019 06:37 AM
Author Name: Frank Grimberg

SQL Server Jobs MSCRM_CONFIG.HardDelete and MSCRM_CONFIG.SiteWideCleanup will never execute the stored procedure unless the database is being mirrored.

Current code in Job
if exists (select * from sys.database_mirroring where mirroring_role = 1 and database_id = DB_ID('MSCRM_CONFIG')) begin exec('use MSCRM_CONFIG; exec p_HardDelete') end

If the MSCRM_CONFIG is not mirrored the value in mirroring_role is null.
I am not sure these jobs really matter - but just an FYI.

Status: Under Review
See more ideas labeled with:
2 Comments (2 New)
Comments
D365Ideas_Admin
D365Ideas_Admin
Level: Powered On
โ€Ž02-04-2019 06:38 AM
Status changed to: Under Review
 
D365Ideas_Admin
D365Ideas_Admin
Level: Powered On
โ€Ž02-04-2019 12:12 PM
Thanks for the feedback this product suggestion looks like it is a bug not a suggestion. We have made note of the issue, this item will be closed out as postponed and this is a bug not a feature. Please use the following link https://community.dynamics.com/crm/p/support.aspx to enter a support case if you would like to make sure to have the issue tracked more closely. Thanks for the feedback. Larry