sql server agent jobs(scheduler)

• kond.mohan

  Grasshopper

  Points: 22

  More actions

  November 10, 2011 at 3:07 am

  #247665

  i want to know usage of sql agent jobs

  how the functionality work

  pls priovide the direction

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  November 10, 2011 at 3:16 am

  #1405595

  http://msdn.microsoft.com/en-us/library/ms189237.aspx

  http://msdn.microsoft.com/en-us/library/ms187061.aspx

  http://databases.about.com/b/2010/07/06/microsoft-sql-server-agent-tutorial.htm

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Iulian -207023

  SSCertifiable

  Points: 7639

  More actions

  November 10, 2011 at 3:23 am

  #1405599

  First you need the SQL Server Agent running. Here is something about the agent:

  http://msdn.microsoft.com/en-us/library/ms189237.aspx

  Then you create your jobs, schedule and maintain them. Here is something about creating the jobs:

  http://msdn.microsoft.com/en-us/library/ms187910.aspx

  The SQL Server Management Studio is pretty intuitive in this area, all you need is a test machine and time to exercise.

  Regards,

  Iulian