The console app doesn't have the context of the site it's running in so you'd have to provide what site ID specifically you want to run it in.
What we do in these instances is create and run the console app locally, simply to test and provide a proof of concept. Then once we've determined it works, we convert it to a scheduled task and register the task with the CMS to run within the contenxt of the given site it was meant for.