Search code examples
sqlsql-servershared-hostingsql-server-agent

Alternative to SQL Server Agent for running jobs on hosting service


What is the alternative for running jobs when the hosting company that provides shared SQL Server services blocks access to SQL Server Agent?


Solution

  • All windows machines have a built in tool, "Windows Task Scheduler" which can run jobs on a schedule determined by you. Its an easy tool to learn and you probably will have to run your jobs using SQLCMD.