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"