Exporting Jobs in SQL Server Agent

Hello,
We have about 20 Jobs in the SQL Server Agent, under the Management section
of the Enterprise Manager tree that run on different schedules daily. We're
moving to a new server and I can't seem to find a way or a tool that will
let me copy the jobs to the new server. Does anyone know if there is a way
or a tool for such a task? We can redo them manually but thought I would ask
first before we started. We're on SQL2K. Thanks for any information you may
be able to give me.
RGPyou can right click on the job and choose Generate SQL Script...
btw, jobs are saved in msdb. :-)
"riley" <riley3@.microtek-sales.com> wrote in message
news:%23lSae4BxDHA.1060@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We have about 20 Jobs in the SQL Server Agent, under the Management
section
> of the Enterprise Manager tree that run on different schedules daily.
We're
> moving to a new server and I can't seem to find a way or a tool that will
> let me copy the jobs to the new server. Does anyone know if there is a way
> or a tool for such a task? We can redo them manually but thought I would
ask
> first before we started. We're on SQL2K. Thanks for any information you
may
> be able to give me.
> RGP
>|||Right click the Jobs under Management | SQL Server Agent
for that SQL Server instance, select All Tasks -> Generate
SQL Scripts ..., and save the SQL script for all the local
jobs.
You can then run this generated script on a differen
server to re-create the jobs. You may need to edit the
script somewhat if the script contains references that are
not valid on this other server.
Linchi
>--Original Message--
>Hello,
>We have about 20 Jobs in the SQL Server Agent, under the
Management section
>of the Enterprise Manager tree that run on different
schedules daily. We're
>moving to a new server and I can't seem to find a way or
a tool that will
>let me copy the jobs to the new server. Does anyone know
if there is a way
>or a tool for such a task? We can redo them manually but
thought I would ask
>first before we started. We're on SQL2K. Thanks for any
information you may
>be able to give me.
>RGP
>
>.
>|||Thank you very much -I didn't realize the Generate SQL Scripts was for that
purpose. Appreciate the help.
RGP
"NEW NAME, OLD GUY" <PLEASE!> wrote in message
news:O4vnJFCxDHA.3436@.tk2msftngp13.phx.gbl...
> you can right click on the job and choose Generate SQL Script...
> btw, jobs are saved in msdb. :-)
> "riley" <riley3@.microtek-sales.com> wrote in message
> news:%23lSae4BxDHA.1060@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> > We have about 20 Jobs in the SQL Server Agent, under the Management
> section
> > of the Enterprise Manager tree that run on different schedules daily.
> We're
> > moving to a new server and I can't seem to find a way or a tool that
will
> > let me copy the jobs to the new server. Does anyone know if there is a
way
> > or a tool for such a task? We can redo them manually but thought I would
> ask
> > first before we started. We're on SQL2K. Thanks for any information you
> may
> > be able to give me.
> > RGP
> >
> >
>

Exporting is not wokring if we place an Image in the Report Header

Hi all..

In my report, i am placing an Image(Embedded) in the Header section. But while i am exporting the document to pdf , it is not displaying any data except the Header Image 3 times. I tried this by placing the image in a List data region also. But still the same problem.

Can any one help me if you come across these kind of issue?

Thanks in advance

Is the image positioned right again the report report border?

Are you using sub reports in the body or is it just straight data?

What is the format of the image?

Will export correctly to Excel?

|||

Exporting to Excel is okay. But to the PDF it is not exporting and displaying the Image(JPEG) thrice.

I placed the image in the header and placed within the report border. I am not using any sub reports. It is straight data.

Can any one faced this kind of problem? pleae give me some solution.

thanks in advance.

|||

Just out of interest, can you change the image type to a gif and try it. I've had PDF exports that have 'issues' with jpg.

export to excel

Hi,

In my report, I have 3 rows in the details section. I need to show all the 3 rows into a single line when it is exported to excel. Is this possible to do in reports, please help me.

I don't understand what you're trying to accomplish; if you can explain in more detail maybe I can give better guidance.

Each row in RDL will be exported to at least one row in Excel (it may span rows depending on the content of the cells and the position of other report items).|||

Hi,

I want to export every 3 lines in my report into 1 line in an excel sheet. Is there any way to do that.

|||Sorry, no.