KB484502: How to programmatically retrieve a list of schedules and subscriptions

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
In Strategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager.

Platform Analytics

The Object Telemetry dossier contains a great deal of subscripton information. You can retrieve subscriptions by filtering for Object Type = Subscriptions/Schedule.
You can also pull up subscriptions and check their status using the Subscription Analysis dossier .

REST API

There are Subscriptions and Schedule endpoints available where you can programatically retrieve schedules and subscriptions.
At the time of this writing, it is not possible to trigger events or subscriptions through the REST API.

Command Manager

There are outlines for subscriptions that allow you to create, maintain, and even trigger subscriptions.
Example:

LIST [ALL] SUBSCRIPTIONS FOR CONTENT (""  IN FOLDER "" | GUID ) FOR PROJECT "";

You can add additional logic by wrapping this up in a Command Manager procedure and Java code.

Web SDK and COM API

If you have a requirement where automation is key, coding against the Web SDK and COM API gives you the most flexibility, despite a steep learning curve and the need for scripting/programming.

SQL Queries Against the Metadata Repository Database

You can query the metadata repository directly.
For subscriptions:

SELECT * FROM public.dsscssubinst;

For schedules:

SELECT * FROM dssmdobjinfo
WHERE object_type in (50,51, 52)
 and object_name LIKE '%Weekly%';

Note on Object Types, 50 Schedule Event, 51 Schedule Object, 52 Schedule Trigger.