QuestionQ62

VerifiedConfigure and manage automation of tasks

You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL Managed Instance named SQLMI1.

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

Which job attribute is not supported in SQLMI1?

Explanation

Azure SQL Managed Instance supports job schedules, email notifications when the required Database Mail profile is configured, and logging job output to a table. SQL Agent job output files require file-system access, which is not available on the managed instance; therefore, output files are unsupported.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!