Skip to main content

beta_schedules

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

Overview

Namebeta_schedules
TypeResource
Idazure.ai_projects.beta_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.
triggerTimestring (date-time)Trigger 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. Retrieves the specified run for a schedule.
getselectid, endpointGet a schedule. Retrieves the specified schedule resource.
listselectendpointtype, enabledList schedules. Returns schedules that match the supplied type and enabled filters.
create_or_updateinsertid, endpoint, enabled, trigger, taskCreate or update a schedule. Creates a new schedule or updates an existing schedule with the supplied definition.
create_or_updatereplaceid, endpoint, enabled, trigger, taskCreate or update a schedule. Creates a new schedule or updates an existing schedule with the supplied definition.
deletedeleteid, endpointDelete a schedule. Deletes the specified schedule resource.
list_runsexecid, endpointtype, enabledList schedule runs. Returns schedule runs that match the supplied filters.

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_idstringThe unique identifier of the schedule run. Required.
schedule_idstringThe unique identifier of the schedule. Required.
enabledbooleanFilter by the enabled status. Default value is None.
typestringFilter by the type of schedule. Known values are: "Evaluation" and "Insight". Default value is None.

SELECT examples

Get a schedule run. Retrieves the specified run for a schedule.

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

INSERT examples

Create or update a schedule. Creates a new schedule or updates an existing schedule with the supplied definition.

INSERT INTO azure.ai_projects.beta_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. Creates a new schedule or updates an existing schedule with the supplied definition.

REPLACE azure.ai_projects.beta_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. Deletes the specified schedule resource.

DELETE FROM azure.ai_projects.beta_schedules
WHERE id = '{{ id }}' --required
AND endpoint = '{{ endpoint }}' --required
;

Lifecycle Methods

List schedule runs. Returns schedule runs that match the supplied filters.

EXEC azure.ai_projects.beta_schedules.list_runs 
@id='{{ id }}' --required,
@endpoint='{{ endpoint }}' --required,
@type='{{ type }}',
@enabled={{ enabled }}
;