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 |
|
satishvsh
Starting Member
41 Posts |
 Posted - 2008-08-01 : 12:50:41
|
| Hello -I am trying to create the job in sql server 2005. This job is already working in sql server 2000. I extracted the script and trying to execute in sql server 2005.Error :Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 243The specified '@notify_email_operator_name' is invalid (valid values are returned by sp_help_operator).Please advise on this.Cheers :)satish |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-01 : 12:51:53
|
| In your SQL Server 2000 job, you've got an operator assigned. And in SQL Server 2005 that operator doesn't exist. So either remove the operator from 2000 and then rescript, modify the script to remove that part of the code, or add the operator to SQL Server 2005.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-01 : 13:14:21
|
| Also make sure DBmail is configured/working if you are migrating operators to SQL 2005 |
|
|
|
satishvsh
Starting Member
41 Posts |
Posted - 2008-08-01 : 13:59:43
|
quote:
Originally posted by tkizer
In your SQL Server 2000 job, you've got an operator assigned. And in SQL Server 2005 that operator doesn't exist. So either remove the operator from 2000 and then rescript, modify the script to remove that part of the code, or add the operator to SQL Server 2005.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
IS there any document how to add an operator in sql server 2005. |
|
|
|
satishvsh
Starting Member
41 Posts |
Posted - 2008-08-01 : 14:00:22
|
DBMail is configured and it is working successfully.quote:
Originally posted by sodeep
Also make sure DBmail is configured/working if you are migrating operators to SQL 2005
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-01 : 14:46:20
|
quote:
Originally posted by satishvsh
quote:
Originally posted by tkizer
In your SQL Server 2000 job, you've got an operator assigned. And in SQL Server 2005 that operator doesn't exist. So either remove the operator from 2000 and then rescript, modify the script to remove that part of the code, or add the operator to SQL Server 2005.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
IS there any document how to add an operator in sql server 2005.
Yes, SQL Server Books Online.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-01 : 15:14:52
|
| Just script out Operators from SQL 2000 to SQL 2005. |
|
|
|
|
|
|
|
|
Job Execution Fails