question

farhan avatar image
farhan asked

different ways to schedule a job in SQL Server 2005

Different ways to schedule a job in SQL Server 2005 and what are the different services in SQL Server 2005.

sql-server-2005sql-agentschedule
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered

The only way to schedule a job that's native to SQL Server is to use the SQL Server Agent process. Any number of third party tools or native OS tools will allow you to call to SQL Server, but Agent is the native process that allows for scheduling.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.