How to configure Index maintaince plans in PAS server

  • Hi ,

     

    i have configured PAS server but sql agent is not there how can i configure index rebuild and update stats automcatilly run.

    can anyone please suggest asap i need asap.

  • Depends on which cloud platform you're on, but every one of them I've worked with have multiple scheduling mechanisms. There's nothing magical about SQL Agent. It's just running T-SQL commands. In AWS, Lambda + RDS or Aurora. In Azure, Azure Logic Apps or Azure Automation. In Google, Cloud Scheduler + Cloud Functions. Those are just the most commonly implemented. There are others built in there.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply