1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

Error when run EXEC procedure in T-SQL Statement Task

Discussão em 'Outras Linguagens' iniciado por Stack, Junho 30, 2021.

  1. Stack

    Stack Membro Participativo

    I created few procedures that I want to run using Maintenance Plan's Execute T-SQL Statement Task box however I'm getting error that job is not found.

    Maintenance Task's configuration: [​IMG]

    Returned error for running EXEC [dbo].[sp_backup_full] N'db_name', N'path/where//to/store/backup':

    End Progress Error: 2021-06-29 18:59:00.42 Code: 0xC002F210 Source: full_backup_and_delete_old_one Execute SQL Task
    Description: Executing the query "EXEC [dbo].[sp_backup_full] N'db_name..." failed with the following error: "Could not find stored procedure 'dbo.sp_backup_full'.".
    Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Continue reading...

Compartilhe esta Página