SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Execute SQL Server Agent Job through T-SQL Syntax
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

funk.phenomena
Posting Yak Master

Canada
120 Posts

Posted - 09/09/2013 :  10:42:02  Show Profile  Reply with Quote
Hi All - I have about 40 jobs loaded in the SQL server agent.

Does anyone here know of way to excecute and/or modify SQL agent jobs through t-SQL syntax?

Thanks!

James K
Flowing Fount of Yak Knowledge

3661 Posts

Posted - 09/09/2013 :  11:49:24  Show Profile  Reply with Quote
Agent jobs are all stored in MSDB. You can use built-in stored procs such as sp_start_job to run the jobs. http://technet.microsoft.com/en-us/library/ms186757.aspx

Some examples here: http://www.interworks.com/blogs/bbickell/2010/01/15/how-execute-and-monitor-agent-job-using-t-sql-sql-server-20052008
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000