scripting jobs using T-sql

  • Any one knows a way to script all jobs in a server? I would like to script them all at once instead of right clicking one by one.

    Also, i am not looking to transfer them, just to script them to save them so SSIS will not work.

    If you know of a way to do it, I would really aprecciate it.

    Thank you,

    Sandra

  • for SQL Server 2005 when you click on jobs and see all the jobs on the summary Tab on the right side, you can highligt all jobs and script all. Hope this helps!

    ¤ §unshine ¤

  • sunshine (4/23/2008)


    for SQL Server 2005 when you click on jobs and see all the jobs on the summary Tab on the right side, you can highligt all jobs and script all. Hope this helps!

    Nice.

    Good catch, Sunshine! I learn something new every day...

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply