title: OK for this to be a SQL Server job?
body: <p>I have a folder that contains images for use badges.  I have another folder that contains renamed versions of the images (this folder is on another machine).</p>
  
  <p>I need to create a process that will copy and rename any new images found.  The mapping between the names is in a SQL Server DB.</p>
  
  <p>Would it be a bad idea to create this as a SQL Server job and use xp_cmdshell to copy the files?  This was my first instinct, but I haven't done this before so I was curious if there were any gottchas i should know about...</p>