When we try to create a SQL Server Agent job schedule that has a recurring frequency type we get the following error:
SQL Server Agent feature Schedule job ONIDLE is not supported in SQL Database Managed Instance. Review the documentation for supported options.
If we click ok to the message and then edit the unsaved schedule, the unaltered scheduled successfully saves. A Profiler trace reveals @freq_type of 128, which is incorrect. That type indicates "Run when the computer is idle.". But when we edit the schedule, make no changes, and it saves successfully, the Profiler trace shows @freq_type=4, which is correct. Has anyone experienced this behavior?
EXEC msdb.dbo.sp_add_jobschedule @job_id=N'18bbf0bd-00ce-4734-b28c-8374a71e3708', @name=N'Test Schedule - Daily',
@active_end_time=235959, @schedule_id = @schedule_id OUTPUT