Are you on an Edition of SQL Server that has SQL Agent? In other words not SQL Express Edition?
If so, I would recommend you setup a SQL Agent Job to run bcp for you. When you setup the job, the Job Step Type will be "Operating System (CmdExec)" and in the command you will put your call to bcp. Then you can schedule the job to run as needed.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato