You can take your bcp command and put it in a .cmd file then use a sql agent job to call that .cmd file.