Sure, scheduled script is definitely an option. However, maybe it's possible to update external table instantly on course creation? Maybe trigger some event to launch update script?
Courses and course formats
Update external database on course creation
This discussion has been locked so you can no longer reply to it.