I tried to copy some SQL Agent Jobs from
server2 by selecting rows from
server1.msdb.dbo.sysjobs and inserting to
server2.msdb.dbo.sysjobs. I did the same with
This seemed to work, and I verified that the records are in the new msdb tables.
Once I restart SQL Agent, I only see some of those jobs listed under SQL Server Agent in SSMS. I am very puzzled why SOME are not listed.
I am using SQL Server 2008 R2.