2 Cireson SQL Jobs fail
In our SQL Server Job Activity Monitor I saw, that 2 of our Cireson jobs fail every day:
- Cireson Insert New Incidents: There is already an object named 'tempTable_Incident' in the database. [SQLSTATE 42S01] (Error 2714). The step failed.
- Cireson Update Existing Changes: There is already an object named 'tempTable_Change' in the database. [SQLSTATE 42S01] (Error 2714). The step failed.
I thought the "IF NOT EXISTS(SELECT [name] FROM tempdb.sys.tables WHERE [name] like 'tempTable_Change%')
BEGIN" checks if the temp table already exists? How could I solve that?