Search code examples
sql-serverwindowssql-server-2008taskscheduler

what is the difference between SQL Job and Windows Task Scheduler?

what is the difference between SQL Job and Windows Task Scheduler ?

AS I can add SQL Queries in both sides ... what is the difference ??

Solution

  • SQLJobs operate in the context of SQLServer Agent which is a part of SQLServer,Scheduling something related to SQLServer like running a query ,maintenance tasks through SQLserver jobs is very easy..

    Whereas task scheduler comes with operating system and you can also schedule tasks,but very difficult to schedule any thing related to sql server,since you have to take care of authentication and many factors