We have a requirement to delete rows from table based on specific condition on remote server.
Let's assume we have two server A and B.
1) Delete rows from table on Server B.
2) Export file using bcp from Server A to Server B through SQL Agent job.
Can anyone please help me with Step 2? How do i setup SQL Agent job using bcp?