scheduling a DBmail command

• aastevo

  SSC Rookie

  Points: 45

  More actions

  April 21, 2015 at 12:35 pm

  #307209

  Hi,

  I have a stored procedure that generates and email once run. This is working perfectly. However, i would like to know how i can schedule the mail to go out in the future eg the next day at 07:30 am.

• JeremyE

  SSCoach

  Points: 16201

  More actions

  April 21, 2015 at 1:55 pm

  #1792560

  You can create a SQL Server Agent job to execute the stored procedure on a given schedule.

  https://msdn.microsoft.com/en-us/library/ms190268.aspx