Before scheduling FlexGet you must must write a configuration file and test that it works correctly. The SQLite database file will get created in the same directory with the configuration file, so please make sure the user executing flexget has write access to that path.
Further more complicated upstart jobs etc can be found Linux/AutoStart
Sit back and relax.