How to Execute and Monitor an Agent Job Using T-SQL in SQL Server 2005/2008
In SQL Server 2005 and 2008 it's possible to start an agent job with T-SQL syntax. This is frequently useful. For example, you may have a job that you'd like to have an outside application invoke. Jobs can also be used to execute SSIS packages....