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.
| Author |
Topic |
|
schilds
Starting Member
4 Posts |
 Posted - 2008-07-10 : 21:28:52
|
| 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 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-10 : 23:47:23
|
| What's sql2k5 sp level? |
 |
|
|
schilds
Starting Member
4 Posts |
Posted - 2008-07-11 : 09:44:59
|
| I guess it is a stored procedure under the msdb database. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-11 : 23:26:25
|
| It is. You may catch bug, did you apply any sql2k5 service pack? |
|
|
|
|
|
|
SQL Job