I found this posting, but I'm completely lost in how to do this.
My need is backup several databases and all the SQL Jobs (Stored Procedures?) from our servers. To make the task easier, I have written a .bat file that can be run on each of the servers to do this. So far, all the databases are being backed up good, I just can't seem to get the SQL Jobs. I know you can right-click on Jobs under SQL Server Agent in Enterprise Manager and generate the SQL script that I can save and use to restore the server. My problem is I can't figure out how they are doing it in the other post.
I know very little about databases, and queries. Can anyone shed some light for me?