Powershell can schedule it for you! Just script something against the SQL Server Agent to get automated now.

Scheduling Jobs in SQL Server Agent [!INCLUDE ssNoVersion] Agent is the service installed by [!INCLUDE ssNoVersion] that lets you automate and schedule tasks by running [!INCLUDE ssNoVersion] Agent ...

SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand. For example, if you want to back up all the company databases every weekday after hours, you can automate ...

SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database. SQL Server Agent can run a job on a ...

How to Find All Scheduled Jobs in SQL. Microsoft's SQL Server database software includes a job scheduling system which lets you perform routine business activities such as reporting and database ...

To do this, we’ll use an SQL Server Agent Job. Using SQL Management Studio, create a new SQL Server Agent Job: Fill in the general details and then go to the Steps page to add a couple of steps.

I want to enable notifications for SQL Agent for my backup jobs.I configured database mail and that works, it sent me a test message.However, when I go to tell the SQL Agent to use it, it sees ...