title: Automated backup of sql server using batch files
body: <p>I have created a stored procedure which takes 3 arguments </p>
  
  <p>databaseName 
  backupType 
  backupLocation</p>
  
  <p>if i run this stored procedure its creating the backup.
  I want to know hw to write a batch file for this and schedule a job to run at specified time.
  I am using sqlserver2008.</p>