DP-300 Certification Practice Question #185

Question

You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1.

You need to move a SQL Server Agent job from DB1 to SQLMI1.

Which job attribute is unsupported in SQLMI1?

Accepted Answer

When migrating a SQL Server Agent job to an Azure SQL Managed Instance, writing job step output directly to local disk physical files (Option D) is unsupported because Managed Instance restricts local file system access. Instead, Microsoft recommends using the "Log to table" option (Option A) to record job execution details directly into `msdb.dbo.sysjobstepslogs`. Email notifications (Option B) are supported via Database Mail using the mandatory profile name `AzureManagedInstance_dbmail_profile`, and schedules (Option C) are also fully supported.

More DP-300 practice questions