Enterprise Manager > script Jobs

  • 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?

  • 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 

  • I've had the same problem, I've only been able to generate one script for a job at a time.

  • 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