October 27, 2021 at 7:22 pm
Hi,
I have a job that rebuilds indexes after a refresh of a replicated report DB.
The issue is sometime I need to restart the SQL Server Agent to get it to start. Is there a command I can use to first restart it?
Thanks
October 27, 2021 at 10:53 pm
Can you explain further? How exactly are you refreshing this? Backup and restore? Replication Snapshot? Something else?
Once the process completes, you then run a re-index process. Why? Are the indexes fragmented?
That process then causes the SQL Agent to stop? Or does the agent never start after a re-boot? In either case, determining the cause of the agent being stopped or not starting is what I would focus on.
Otherwise, you can use the NET START command to start the service.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply