Winform interface to sql server agent jobs

• Chabian

  Grasshopper

  Points: 13

  More actions

  June 20, 2011 at 12:52 pm

  #242418

  I want to allow my users to create their own scheduled jobs in SQL Server Agent. Can this be done, or do they have to have access to Enterprise Manager to do this? If it can be done through Winforms, can you please point me in the direction of a good tutorial or forum post?

  Thanks

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  June 20, 2011 at 2:18 pm

  #1341442

  It sounds a little bit like you're aiming to re-invent the wheel...are you sure this is something you want to give users the ability to do?

  If you must, then here is the reference document containing all the stored procedures you will need to manage SQL Agent job creation:

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

  These procs coupled with knowledge of these tables in the msdb database should give you what you need to get started:

  dbo.sysjobactivity

  dbo.sysjobhistory

  dbo.sysjobs

  dbo.sysjobschedules

  dbo.sysjobservers

  dbo.sysjobsteps

  dbo.sysjobstepslogs

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato