Skip to content Skip to sidebar Skip to footer

SQL Server - Sp_verify_job @name Already Exists

I am trying to create a job on a SQL Server 2017 instance from an SSIS package. This SSIS package was created from the Import and Export wizard. All the job does is update a table

Solution 1:

The name in the error message is the job name and not the @name variable which is the job category name in the code. Your question suggests you already created the job using the import/export wizard, and now it fails through SSIS because it already exists. So, try:

Changing the @job_name variable or Dropping the job before trygin to create it again


Post a Comment for "SQL Server - Sp_verify_job @name Already Exists"