Jobs in SQL Management Studio

• Vinay Theethira

  Right there with Babe

  Points: 775

  More actions

  June 22, 2009 at 6:17 am

  #135520

  Hi all,

  Can anyone tell me if i can call a Stored Procedure when creating and scheduling jobs, instead of writing the Query in the Command.

  If yes, can u plz refer me a link or article so that i can study on that.

  Thank u all.

• Grant Fritchey

  SSC Guru

  Points: 398886

  More actions

  June 22, 2009 at 7:35 am

  #1013283

  You can. I don't have a link for you. It's just:

  EXEC @param1=42

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning