Can't find Maintenance Plan Task under Management and Toolbox options are grayout in MS Sql Server 2019 Standard edition.

Gowrab Das Dip 41 Reputation points


I have installed MS sql 2019 standard edition in our rhel 8 os. I have tried to create maintenance plan , but it seems disabled from ssms. I have already tried in SSMS 18.x and 19.x and find the same issue. please help me to get through over this problem.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,912 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 41,496 Reputation points

    I have installed MS sql 2019 standard edition in our rhel 8 os.

    Maintanance plans are not supported by SQL Server on Linux, see Release notes for SQL Server 2019 on Linux => SQL Server Management Studio (SSMS) => Maintenance plans aren't supported.

    0 comments No comments

  2. YufeiShao-msft 7,061 Reputation points

    Hi @Gowrab Das Dip

    On Linux Server, maintenance plans are not supported


    As an alternative, you can try to create your own SQL Server jobs to perform backups, index and statistics maintenance, you can check out this article: SQL Server on Linux: Running jobs with SQL Server Agent


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  3. Olaf Helper 41,496 Reputation points

    I want to schedule back-up (Every Day) my databases via ssms-18

    SSMS is just a tool/frontend.
    Use a Linux CRON job to schedule backup the databases:,other%20commands%20to%20run%20automatically.

    0 comments No comments