Simple way to create a SQL Server Job Using T-SQL

Posted on SQL Server Central See other posts from SQL Server Central
Published on Tue, 08 Oct 2013 06:00:00 UT Indexed on 2013/10/17 16:17 UTC
Read the original article Hit count: 240

Filed under:

Sometimes we have a T-SQL process that we need to run that takes some time to run or we want to run it during idle time on the server. We could create a SQL Agent job manually, but is there any simple way to create a scheduled job?

sqldbabundle The seven tools in the SQL DBA Bundle support your core SQL Server database administration tasks.
Make backups a breeze! Enjoy trouble-free troubleshooting! Make the most of monitoring! Download a free trial now.

© SQL Server Central or respective owner