automate mysql db content

I have static content that I want to periodically load into my wordpress blog. My content is stored in a mysql database. I plan to write a script to draw one entry at a time from the database and then automate the script with a cron job.

Where do i put my script or (ideally) set up this configuration so that it runs natively in WordPress? Is there already a way to do it without me having to write the script?

Additionally I’d like to grab the content from another one of my sites instead of from a database in the same host. Any ideas for this?