Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SQL Jobs

Author  Topic 

schilds
Starting Member

4 Posts

Posted - 2008-07-10 : 21:31:29
I have created a ssis package importing data from an excel spreadsheet into a table. This ssis pack. works fine. I then created a job to fire this ssis pack. When i run the job it fails. The log files do not give anything other than it failed. When i export it to a query window it parses fine but when ran it i receive this error. Procedure failed sp_verify_job line 56 @name ('name of job') already exist. Now there aren't any other jobs with this name. No matter what name i give my job i get the same error. Can someone shed some light on this problem. It is driving me crazy.

Thanks in advance!
SC

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2008-07-10 : 23:32:15
Please do not open multiple threads for same question: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=106413

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -