quote:

---

Do both SQL Srever have same version and service pack?

Test server has Developer edition with sp3 and production has Enterprise with sp3

...

Thank you very much, it works on the test server and i used the account for sqlagent

but when i tried the same procedire on production i got this error :

xpsql.cpp:...

quote:

---

From EM --> Management --> SQL Server Agent --> properties --> Job System --> uncheck 'Only user with sysadmin ....'. Please ensure...