• Sugesh, thanks for trying but I need to script out ALL the jobs and the first URL is the SSMS method to script out a single job and the second site requires that I pay to subscribe to get the code (as its a trade mag), and its for SQL 2000 anyway (don't know if it would still work)

    If anyone has code for SQL 2005 I would appreciate it.

    george

    ---------------------------------------------------------------------