For a Joomla blog, we want to be able to create the blog Joomla articles and schedule them with a start publication date when they appear on the website. We also want them to automatically be posted to the company's Facebook Fan Page, and Twitter account.
Is there a Joomla extension that would accomplish this and recognize the posting would coincide with the start publication date of the Joomla Article?
I assume something in the CRON needs to be scheduled to do this? If so, is this a simple shell/PHP script to look at the MySQL database for this Joomla installation and handle the auto posting through an API for Facebook and Twitter? Or is this re-inventing the wheel and there is already a Joomla extension solution for this?