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 |
|
tfountain
Constraint Violating Yak Guru
491 Posts |
 Posted - 2008-04-21 : 13:37:19
|
While attempting to script out some multi-server jobs I am receiving this error:TITLE: Microsoft SQL Server Management Studio------------------------------Script failed for Job 'my job name'. (Microsoft.SqlServer.Smo)For help, click: <link removed to keep message width to a normal size :)>------------------------------ADDITIONAL INFORMATION:Unable to cast object of type 'System.DBNull' to type 'System.String'. (Microsoft.SqlServer.Smo)------------------------------BUTTONS:OK------------------------------ This happens on any multi-server job. The reason behind needing to script this is the current database server that acts as our master server for SQL Server jobs is being replaced. I figured it would be easy enough to script out the job on the old server and run it (with minimal modifications) on the new server. Now, if I create any of these jobs manually on the new server and try to script it, it works just fine. Any ideas what might be the issue here?I've tried doing it via SSMS from multiple servers and the issue persists. |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-04-21 : 14:03:09
|
| I've ran a profile on this and it appears that the procedure msdb.dbo.sp_help_jobserver is returning null records. Is it possible I have something orphaned? |
 |
|
|
|
|
|
Errors scripting out multi-server jobs