Support OwnerLoginName in New-DbaAgentSchedule

[david-garcia-garcia]

Type of Change

• [x] New feature (non-breaking change )

  Purpose

  It is not possible to create a schedule inside a container when interacting with MSSQL using Integrated Authentication and the user is the default ContainerAdmin:

C:\entrypoint\refreshenv\ConfigureMssqlJobs.ps1 : The specified
mssql-1  | '@owner_login_name' is invalid (valid values are returned by sp_helplogins
mssql-1  | [excluding Windows NT groups]).

It looks like this default account has some sort of trait that prevents it from being the owner of a Schedule. You can create jobs using other users as owners.

Approach

Allow to manually set the Ownership of the schedule during creation.

[potatoqualitee]

Tests pass, fab job. Thank you 🙇🏼