Recurring/Scheduling Work Items

Looking for Feedback on how you do/have seen successful processes for recurring/scheduling Work Items.

We are working on creating a process for recurring/scheduling Work Items.
Current plan is a SQL table with basic info such as Work Item Type (IR/SR/CR), Category of ticket(such as audit, patching, etc.), Schedule(Weekly, Monthly, Quarterly, etc.), and other fields. With the premise to then use Orchestrator to review the SQL table once a day, then create the applicable ticket.

This seemed like a decent idea in concept and throughout testing, however now I am looking for alternative. With the thought in mind of ease in process to adjust, add to, etc.

Oskar Landman, had this as an example: http://www.systemcentercentral.com/scheduling-work-items-in-scsm-natively/

And then this blog post is similar to what we envisioned: https://getoutofmycloud.com/blog/generate-scsm-work-items-with-orchestrator-scheduled-tasks/

I know that we could use the Authoring Tool, however we have not created workflows like this before therefore I am not sure of the overhead/ease in the event we needed to transfer these responsibilities.

Any Advice/Feedback on how you do/have seen successful processes for recurring/scheduling Work Items would be greatly appreciated!
2 replies