Scheduling a job in SQL 2005 -- How to?

• Mark F-428640

  Hall of Fame

  Points: 3659

  More actions

  July 23, 2008 at 9:11 am

  #191398

  How do you schedule a job in SQL 2005 -- I am simply looking to fire a S.P. at a specific time?

  thanks,

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  July 23, 2008 at 9:32 am

  #847145

  In SSMS connect to a server using Object Explorere then Go to SQL Server Agent -> Jobs. Right-click -> New Job, etc..

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  July 23, 2008 at 9:34 am

  #847148

  Hi,

  Under the server instance name, u can see 'SQL server Agent' -> Jobs -> New Job - > Schedule -> New and select the schedule.

  If you cant see 'SQL Server Agent' it means you dont have access to create it.

  I am not sure if this is the only information that you are looking for.

  Regards,

  Prakash.P

  ---------------------------------------------------------------------------------

• Mark F-428640

  Hall of Fame

  Points: 3659

  More actions

  July 23, 2008 at 10:38 am

  #847199

  Thanks all this is exactly what I needed -- apparently I didn't have correct permsissions -- no wonder I couldn't find it.

  Cheers,