Back-up Jobs

Greetings
I hope this is an easy question. I have a set of database (16 of them). I
have been using the enterprise manager to set-up back-up jobs for each one.
Can I use a script to insert the jobs in the SQL agent's job queue?
Thanks
Marc Walgren
Marc Walgren
Mitten Software "Powerful Solutions Made Easy"
1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
Providing Web and Windows Products and Consulting Services
----
e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944If I understand your question right, then yes, you can create the backup
scripts on your own. You just need to learn the BACKUP command, which is
documented in SQL Server Books Online.
Also, you can generate a script for an existing job, using Enterprise
Manager. Then you can change the parameters of that script, to create your
own job.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marc Walgren" <marcmittenATyahoo.com> wrote in message
news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> Greetings
> I hope this is an easy question. I have a set of database (16 of them). I
> have been using the enterprise manager to set-up back-up jobs for each
one.
> Can I use a script to insert the jobs in the SQL agent's job queue?
> Thanks
> Marc Walgren
> --
> Marc Walgren
> Mitten Software "Powerful Solutions Made Easy"
> 1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
> Providing Web and Windows Products and Consulting Services
> ---
--
> e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
> Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
>
>|||Thanks
I forgot to look for the "Generate Sql Script" option on the job - all task
popup menu.
Marc
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23YNTGMEwEHA.3916@.TK2MSFTNGP10.phx.gbl...
> If I understand your question right, then yes, you can create the backup
> scripts on your own. You just need to learn the BACKUP command, which is
> documented in SQL Server Books Online.
> Also, you can generate a script for an existing job, using Enterprise
> Manager. Then you can change the parameters of that script, to create your
> own job.
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Marc Walgren" <marcmittenATyahoo.com> wrote in message
> news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> one.
> --
>