November 23, 2017 at 4:13 am
Hello, guys.I thinking for something but not really sure.Is it possible to make a endpoint in sql server 2012 for notify me in my asp.net project when sql server agen job is prepare to run.Because i have a mvc site where is running daily reports and also is running log shipping and you know when restore job start (all users is disconnected), so i have to know when this job is prepare to run with kinda endpoint or something else.For now i have a little decision i put all steps in one job.Start Copy job then stop site with powershell scripts start maintenance page and etc... Thank you 🙂
November 23, 2017 at 4:23 am
Query msdb.dbo.sysjobs and msdb.dbo.sysjobschedules to pull out the next run date and time for the copy and restore jobs, then you can see when it is going to start to kick people out and you can put the temporary maintenance in place.
Alternatively would be to not force people out but then you are only as good as your last restored log, so if people are in it 8 hours a day constantly, your always 8 hours behind.
You could also look at other things like replication or building SSIS packages to move data from A to B instead.
Also hope you have licensed the logshipping secondary for production use as your serving user requests from it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply