We have around 40+ jobs in the server box which hosts 5 DB instances
, of which i need to script some of the jobs to be run on a different server for testing.
I need all the jobs which use a particuler DB only .
Is there any Way i can filter and genrate scripts from SQLAgent,
If i give a 'wordsearch' like the DB name ,