September 16, 2005 at 7:38 am
Please can you help,
it used to be that you could go to Eterprise Manager/Jobs > highlight multiple jobs > right click > All Tasks > Generate SQL Script and the jobs could be scripted out to file.
at some point in the past we seem to have lost that ability, when we now do the above actions it only scripts out the 1st job selected.
does anyone know how to turn this feature back on?
September 16, 2005 at 8:27 am
I don't think SQL server ever has this feature.
However, if you right click SQL Agent-->Jobs and in the context menu select all tasks --> generate script, it will generate scripts for ALL jobs
September 16, 2005 at 9:16 am
I've had the same problem, I've only been able to generate one script for a job at a time.
July 13, 2006 at 12:35 pm
yeah... the problem here is that when you go to the 'Jobs' category under
the SQL Agent, and goto All Tasks, then generate a script for all jobs,
it's not like it gives you different 'files' for each job.
we are talking one MASSIVE script which comprises of ALL jobs on the
server. you would have to split each part into it's own scripts.
_________________________
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply