April 14, 2014 at 8:05 am
Hi all,
Is there a 'best practice' for bringing scheduled jobs across from SQL 2000? I've generated a script but it comes back chock-full of errors when I hit Ctrl + L. Also this is a new box, so can't upgrade them.
Is the SSIS 'Transfer Tasks' component better for this purpose?
Cheers,
Jake.
April 14, 2014 at 9:51 am
What errors are you getting ..
--
SQLBuddy
April 14, 2014 at 10:05 am
Msg 208, Level 16, State 0, Procedure sp_delete_job, Line 95
Invalid object name '#temp_jobs_to_delete'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
Msg 208, Level 16, State 0, Procedure sp_sqlagent_has_server_access, Line 100
Invalid object name '#xp_results'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
Msg 208, Level 16, State 0, Procedure sp_post_msx_operation, Line 117
Invalid object name '#target_servers'.
Msg 208, Level 16, State 0, Procedure sp_post_msx_operation, Line 117
Invalid object name '#target_servers'.
Msg 208, Level 16, State 0, Procedure sp_sqlagent_has_server_access, Line 100
Invalid object name '#xp_results'.
Msg 208, Level 16, State 0, Procedure sp_post_msx_operation, Line 117
Invalid object name '#target_servers'.
Msg 208, Level 16, State 0, Procedure sp_delete_job, Line 95
Invalid object name '#temp_jobs_to_delete'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
Msg 208, Level 16, State 0, Procedure sp_sqlagent_has_server_access, Line 100
Invalid object name '#xp_results'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
Msg 208, Level 16, State 0, Procedure sp_post_msx_operation, Line 117
Invalid object name '#target_servers'.
Msg 208, Level 16, State 0, Procedure sp_post_msx_operation, Line 117
Invalid object name '#target_servers'.
Msg 208, Level 16, State 0, Procedure sp_sqlagent_has_server_access, Line 100
Invalid object name '#xp_results'.
Msg 208, Level 16, State 0, Procedure sp_post_msx_operation, Line 117
Invalid object name '#target_servers'.
Msg 208, Level 16, State 0, Procedure sp_delete_job, Line 95
Invalid object name '#temp_jobs_to_delete'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
Msg 208, Level 16, State 0, Procedure sp_sqlagent_has_server_access, Line 100
Invalid object name '#xp_results'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
Msg 208, Level 16, State 0, Procedure sp_post_msx_operation, Line 117
Invalid object name '#target_servers'.
Msg 208, Level 16, State 0, Procedure sp_post_msx_operation, Line 117
Invalid object name '#target_servers'.
Msg 208, Level 16, State 0, Procedure sp_sqlagent_has_server_access, Line 100
Invalid object name '#xp_results'.
Msg 208, Level 16, State 0, Procedure sp_post_msx_operation, Line 117
Invalid object name '#target_servers'.
Msg 208, Level 16, State 0, Procedure sp_delete_job, Line 95
Invalid object name '#temp_jobs_to_delete'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
Msg 208, Level 16, State 0, Procedure sp_sqlagent_has_server_access, Line 100
Invalid object name '#xp_results'.
Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34
Invalid object name 'tempdb.dbo.MSreplication_agent_status'.
April 14, 2014 at 10:29 am
Looks like you are using replication on 2000 server. Are you going to move it to the new server or re-setup replication on SQL 2005 server ?
BTW, how did you generate the script for those jobs ?
--
SQLBuddy
April 15, 2014 at 2:04 am
I've checked, there's no current replication on that box. The script was generated by right click, 'Generate SQL Script'....
April 15, 2014 at 2:16 am
I MIGHT have validated against source, not destination, dohh...here is the error output now.
Msg 213, Level 16, State 1, Procedure sp_delete_all_msx_jobs, Line 25
Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Procedure sp_delete_all_msx_jobs, Line 25
Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Procedure sp_delete_all_msx_jobs, Line 25
Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Procedure sp_delete_all_msx_jobs, Line 25
Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Procedure sp_delete_all_msx_jobs, Line 25
Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Procedure sp_delete_all_msx_jobs, Line 25
Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Procedure sp_delete_all_msx_jobs, Line 25
Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Procedure sp_delete_all_msx_jobs, Line 25
Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Procedure sp_delete_all_msx_jobs, Line 25
Column name or number of supplied values does not match table definition.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply