Recovery Action For Specified Subsystem Is Not Valid Sp_enum_sqlagent_subsystems

The one stop solution for all your Windows related problems

  • Step 1: Download and install ASR Pro
  • Step 2: Open the application and click on the Scan button
  • Step 3: Select the files or folders you want to restore and click on the Restore button
  • Get a faster

    You may encounter an error indicating that the specified subsystem is invalid sp_enum_sqlagent_subsystems. It turns out there are several steps you can take to fix this problem. We will talk about this now.

    residencesql errorSQL Server Upgrade

    The one stop solution for all your Windows related problems

    Is your computer running slow and unstable? Are you plagued by mysterious errors, and worried about data loss or hardware failure? Then you need ASR Pro the ultimate software for repairing Windows problems. With ASR Pro, you can fix a wide range of issues in just a few clicks, including the dreaded Blue Screen of Death. The application also detects crashing applications and files, so you can quickly resolve their problems. And best of all, its completely free! So dont wait download ASR Pro now and enjoy a smooth, stable and error-free PC experience.

  • Step 1: Download and install ASR Pro
  • Step 2: Open the application and click on the Scan button
  • Step 3: Select the files or folders you want to restore and click on the Restore button

  • > Disappointing SQL Job Creation (with VBScript Step) after SQL 2016/2017 Update

    Error Creating SQL Server Job (with VBScript Step) After Upgrade From SQL Server 2016/2017

    A guy contacted me yesterday and said that most of them are having trouble running a bunch of SQL DDL production scripts at the same time. They upgraded their version of SQL Server from 2008 to 2016 when they encountered the following error while creating SQL jobs:

    the specified subsystem is invalid sp_enum_sqlagent_subsystems

    Msg 14234, Level 2007, State 1, Procedure sp_verify_subsystem, Line 28 [Package Launch Line 2]
    “@Subsystem” is invalid (valid values ​​are recovered by sp_enum_sqlagent_subsystems).

    I checked the code, and then with a quick query, I saw that one of the steps in the SQL job was configured for your own VB script as shown below:

    …EXEC @ReturnCode matches [email protected] job_id = @ jobId,@ step_name = N’xyz VBScript ‘,@ step_id = 3,@ cmdexec_success_code = 0,@ on_success_step_id = 0,@ on_success_action = 4,@ on_fail_action = 5,@ on_fail_step_id = 0,@ retry_attempts = 0,@ retry_interval = 0,@ os_run_priority = 0,@ subsystem = N’ActiveScripting ‘,…

    When I quickly searched the Internet,I found out that this function is stopped and cannot be used.

    ** Important * * This feature will be cleaned up in a future version of Microsoft SQL Server. Avoid using all of these features in new work instructions for developing and modifying applications that currently use this feature.
    MS BoL-Link

    ActiveX will be disabled permanently. Use Command Prompt or PowerShell scripts instead.


    In Microsoft SQL Server 2005, when you run a new maintenance plan that learns on a schedule, you may often receive the following error message:

    Failed to create service organization. More information about the error: Create a Subplane task for the step. (Microsoft.SqlServer.MainastedPlanTasks) Custom exception while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Specified connectioninfo) ‘@subsystem’ is usually invalid (valid values ​​provided by sp_enum_sqlagent_subsystems). (Microsoft SQL Server Error 14234) This issue occurs because you do not install the Integration Service from the SQL Server 2005 CD, just add the component and the error may not appear anymore.

    Handler.handleException [: 257] – java.sql.SQLException: Connection failed. The connection comes from a trusted untrusted domain and cannot be used for Windows authentication.

    This message can appear for several reasons. One of the reasons for this could be the useNTLMv2 parameter. If you receive this error message when using Windows Authentication, you may need to set useNTLMv2 to TRUE. If there is a breakout, it is set to FALSE. Now, if you are using Windows Authentication with the jTDS driver, the db.Url property can be set for the properties file.

    The specified “@subsystems” is invalid (correct thought is returned by sp_enum_sqlagent_subsystems).

    If you use the agent under the correct conditions, Microsoft SQL Server will generate the following error: The specified “@subsystem” is usually not valid (valid values ​​are returned as well as sp_enum_sqlagent_subsystems).

    Syntax

     sp_enum_sqlagent_subsystems 

    Arguments

    Return Code Values ​​

    Result Sets

    Column name data type Description
    Subsystem nvarchar (40) The name of the subsystem that.
    Description nvarchar (512) Subsystem description.
    dll_system nvarchar (510) The DLL module containing these subsystems.
    agent_exe nvarchar (510) The executable is used for the subsystem.
    start_point nvarchar (30) The method that SQL Server Agent calls when performing step-by-step tasks.
    event_start nvarchar (30) A procedure that, unfortunately, calls SQL Server Agent when it takes steps in a possible job.
    end_point nvarchar (30) The procedure that SQL Server Agent calls during a job step.
    max_worker_threads integer The maximum number of SQL threads that the Server Agent can run for this subsystem.
    subsystem_id integer Identifier of the corresponding subsystem.

    Permissions

    By default, members of most of the fixed roles on the sysadmin server can run this stored procedure. Other users must have a fixed portion of the SQLAgentOperatorRole database in the msdb database.

    For more information on SQLAgentOperatorRole, see SQL Server Fixed Solution Database Roles .

    See Also

    • Article
    • 2 minutes to read.

    the specified subsystem is invalid sp_enum_sqlagent_subsystems

    Get a faster

    Поведение при восстановлении для указанной подсистемы не очень хорошее Sp_enum_sqlagent_subsystems
    A Ação De Recuperação Para O Subsistema Especificado Quase Certamente Não é Válida Sp_enum_sqlagent_subsystems
    L’azione Di Ripristino Per Il Sottosistema Specificato Non è Sempre Stata Valida Sp_enum_sqlagent_subsystems
    La Acción De Recuperación Para El Subsistema Especificado Definitivamente No Es Válida Sp_enum_sqlagent_subsystems
    L’action De Récupération Pour Le Sous-système Spécifié N’est Généralement Pas Valide Sp_enum_sqlagent_subsystems
    Herstelconcept Voor Gespecificeerd Subsysteem Is Nooit Geldig Sp_enum_sqlagent_subsystems
    Återställningsåtgärd För Distinkta Delsystem är Inte Giltig Sp_enum_sqlagent_subsystems
    지정된 하위 시스템에 대한 복구 작업이 우수하지 않습니다. Sp_enum_sqlagent_subsystems
    Wiederherstellungsbewegung Für Das Angegebene Subsystem Ist Nicht Seriös Sp_enum_sqlagent_subsystems

    Bookmark the permalink.