Last time I had a problem that 'scheduled agent in my local database is not running eventhoug I am able to run manually'. Later I found that the database should be in data folder for running the scheduled agents in local.
Follow the following check list when having problem with running scheduled agents in local.
1. See you are able to successfully run the agent manually.
2. Go to Cleint. File->Preferences->User Preferences->Basics Tab; check 'Enable scheduled local agents'
3. Check whether the database is in data folder.