SQL error 2714

[ddtpmyra]

I have job scheduler inside the MS SQL the job sometimes and sometimes fail. How can I avoid this?

ERROR MSG:
There is object name 'run_job' in the database. SQL STATE: 42S01 ERROR 2714.

[Rabbit]

The error is that the object you're trying to create already exists in the database. Either don't recreate it or check for its existence and drop it before creating it again.

[ddtpmyra]

thanks Rabbit, what I found there's another procedure that runs that using the same table name.