Skip to main content

schedules

Creates, updates, deletes, gets or lists a schedules resource.

Overview

Nameschedules
TypeResource
Idazure.ai_evaluation.schedules

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringIdentifier of the schedule run. Required.
errorstringError information for the schedule run.
propertiesobjectProperties of the schedule run. Required.
scheduleIdstringIdentifier of the schedule. Required.
successbooleanTrigger success status of the schedule run. Required.
triggerTimestringTrigger time of the schedule run.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_runselectschedule_id, run_id, endpointGet a schedule run by id.
getselectid, endpointGet a schedule by id.
list_runsselectschedule_id, endpointList all schedule runs.
listselectendpointList all schedules.
create_or_updateinsertid, endpoint, enabled, trigger, taskCreate or update a schedule by id.
create_or_updatereplaceid, endpoint, enabled, trigger, taskCreate or update a schedule by id.
deletedeleteid, endpointDelete a schedule.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
endpointstringThe service endpoint host (no scheme), e.g. myaccount.table.cosmos.azure.com:443 - value of the client endpoint parameter. (default: )
idstringIdentifier of the schedule. Required.
run_idstringIdentifier of the schedule run. Required.
schedule_idstringIdentifier of the schedule. Required.

SELECT examples

Get a schedule run by id.

SELECT
id,
error,
properties,
scheduleId,
success,
triggerTime
FROM azure.ai_evaluation.schedules
WHERE schedule_id = '{{ schedule_id }}' -- required
AND run_id = '{{ run_id }}' -- required
AND endpoint = '{{ endpoint }}' -- required
;

INSERT examples

Create or update a schedule by id.

INSERT INTO azure.ai_evaluation.schedules (
displayName,
description,
enabled,
trigger,
task,
tags,
properties,
id,
endpoint
)
SELECT
'{{ displayName }}',
'{{ description }}',
{{ enabled }} /* required */,
'{{ trigger }}' /* required */,
'{{ task }}' /* required */,
'{{ tags }}',
'{{ properties }}',
'{{ id }}',
'{{ endpoint }}'
RETURNING
id,
description,
displayName,
enabled,
properties,
provisioningStatus,
systemData,
tags,
task,
trigger
;

REPLACE examples

Create or update a schedule by id.

REPLACE azure.ai_evaluation.schedules
SET
displayName = '{{ displayName }}',
description = '{{ description }}',
enabled = {{ enabled }},
trigger = '{{ trigger }}',
task = '{{ task }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
id = '{{ id }}' --required
AND endpoint = '{{ endpoint }}' --required
AND enabled = {{ enabled }} --required
AND trigger = '{{ trigger }}' --required
AND task = '{{ task }}' --required
RETURNING
id,
description,
displayName,
enabled,
properties,
provisioningStatus,
systemData,
tags,
task,
trigger;

DELETE examples

Delete a schedule.

DELETE FROM azure.ai_evaluation.schedules
WHERE id = '{{ id }}' --required
AND endpoint = '{{ endpoint }}' --required
;