Scheduling SQLAgent job using t-sql

• rambilla4

  SSCrazy Eights

  Points: 8715

  More actions

  April 7, 2010 at 10:13 am

  #146403

  Hi,

  I have an existing SQLAgent job called 'Backup'in sql server 2005. I just want to run this job like at 5:00 AM tomorrow (04/08/2010)

  I know how to do this from SSMS but want to know the t-sql script for this.

  Thanks

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  April 7, 2010 at 10:22 am

  #1147527

  Hi Ram,

  You can script the Job from the SSMS.

  Right click on the Job --> Script Job as --> create to-->New Query Editor window.

  Thank You,

  Best Regards

  SQLBuddy.