Configures the Automatic SPM Evolve Advisor task.

POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlPlanBaselines/actions/configureAutomaticSpmEvolveAdvisorTask

Configures the Automatic SPM Evolve Advisor task SYS_AUTO_SPM_EVOLVE_TASK by specifying task parameters. As the task is owned by SYS, only SYS can set task parameters.

Request Body

{"taskParameters"=>{"allowedTimeLimit"=>"<integer>", "alternatePlanBaselines"=>["AUTO", "AUTO"], "alternatePlanLimit"=>"<integer>", "alternatePlanSources"=>["CURSOR_CACHE", "SQL_TUNING_SET"], "arePlansAutoAccepted"=>"<boolean>"}, "credentials"=>{"credentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"NORMAL"}, "databaseCredential"=>{"credentialType"=>"PASSWORD"}}

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
Content-Typestring
Acceptstring

RESPONSES

status: OK

&quot;&quot;