I am trying to Schedule an item to be target published from UAT to a Production environment, is there a solution for this? Because as I understand out of the box, it does not work, I have tried many different options, different agents were implemented. But there was no solution that allowed me to "schedule" to a "target" database. So my scenario is as following, I have UAT(CM) environment, and I want to target publish from it to the my Production(CD), but I also would like to schedule the publishing, I would like to save it and see it right away in UAT, but for the production I would like to schedule for the future day.
The typical approach would be to have multiple publishing targets. The standard 'Web' one would be where you publish on your UAT (CM) and your CD would be pointed at a different database (let's call it 'Delivery').
When you are logged into CM, you can choose which publishing targets to push to: 'Web' or 'Delivery'.
You can also configure a publishing agent or use a publishing module for scheduled publishing to push out to the 'Delivery' database.
Some scheduled publishing modules: