Sql server intellisense not updating gay speed dating reading
Then right-click on Jobs and select New Job and give the job a name.
Note that the owner column will default to you the logged in user.
The best part of this is if you have multiple clients like I do is that you can script out the job, change the variables and use it over and over again.
To do so, click OK on the screen above and then click on Notifications in the left menu. Please note that you must have db Mail enabled and configured in order for this to work as well as operators setup on your server.
I’m not going to go through how to configure db Mail or adding operators as they are already readily available from other sources.
Once notification is completed, click on Schedules in the left menu then click new. For my example here, I have scheduled a daily job that runs at AM with no end date.
This is a quick and easy way to restore a database via a script that can be automated.
Again, to automate this, I put a script into a SQL Agent Job and scheduled it to run on a daily basis at a specific time.
I usually change this to SA or a user with SA but that is up to you. Click on the New button in the lower portion of the screen.