Scheduled report by email with attached report fails

Can anyone offer any help with this?

Error maesage:
Status:
Failure sending mail: The Report Server has encountered a configuration error; more details in the log files

Windows 200 Server: SP4
RS 2000: SP2
SQL Server 2000, on the same server as RS.

We

get this error whenever we try to run a report with the report

attached. However, the email sends fine if the report is not attached.

Reports can also be exported into different formats without problem when viewing the report through report manager.
I received a email telling me there had been a reply to this thread, but I see nothing.

Can anyone help with this?|||Did you check the log files to see what the error is?|||Bringing this topic back from the dead a little I know, but I've finally had chance to get back to trying to use this since being switched onto other projects.

Which log would likely contain the information needed.
The logs located at: C:\Program Files\Microsoft SQL Server\MSSQL\LOG
called: SQLAGENT.OUT ?|||I am having the same problem. The report service log file only re-iterates the message, and does not provide any further details.
I checked the Report Server configuration file and it looks okay, nothing unusual.
Does anyone have any idea what may be causing the problem?|||

The RS log files are located here:

%Program Files%\Microsft SQL Server\MSSQL.2\Reporting Services\LogFiles

The Windows Service log file (which processes subscription events) should have a name like this:

ReportServerService__03_19_2007_00_01_09.log

|||

No entry is made in that folder when it fails the job.

However, we have noticed that if my colleague creates the subscription then it works fine without the error. So I suspect it might be related to permissions in sql server or on the win 2000 server box. So far I've been unable to determine which permission is causing it. Despite ensuring I am in the same permission groups as he is, my subscriptions still fail.

Scheduled report by email with attached report fails

Can anyone offer any help with this?

Error maesage:
Status:
Failure sending mail: The Report Server has encountered a configuration error; more details in the log files

Windows 200 Server: SP4
RS 2000: SP2
SQL Server 2000, on the same server as RS.

We

get this error whenever we try to run a report with the report

attached. However, the email sends fine if the report is not attached.

Reports can also be exported into different formats without problem when viewing the report through report manager.
I received a email telling me there had been a reply to this thread, but I see nothing.

Can anyone help with this?|||Did you check the log files to see what the error is?|||Bringing this topic back from the dead a little I know, but I've finally had chance to get back to trying to use this since being switched onto other projects.

Which log would likely contain the information needed.
The logs located at: C:\Program Files\Microsoft SQL Server\MSSQL\LOG
called: SQLAGENT.OUT ?|||I am having the same problem. The report service log file only re-iterates the message, and does not provide any further details.
I checked the Report Server configuration file and it looks okay, nothing unusual.
Does anyone have any idea what may be causing the problem?|||

The RS log files are located here:

%Program Files%\Microsft SQL Server\MSSQL.2\Reporting Services\LogFiles

The Windows Service log file (which processes subscription events) should have a name like this:

ReportServerService__03_19_2007_00_01_09.log

|||

No entry is made in that folder when it fails the job.

However, we have noticed that if my colleague creates the subscription then it works fine without the error. So I suspect it might be related to permissions in sql server or on the win 2000 server box. So far I've been unable to determine which permission is causing it. Despite ensuring I am in the same permission groups as he is, my subscriptions still fail.

Scheduled report by email with attached report fails

Can anyone offer any help with this?

Error maesage:
Status:
Failure sending mail: The Report Server has encountered a configuration error; more details in the log files

Windows 200 Server: SP4
RS 2000: SP2
SQL Server 2000, on the same server as RS.

We get this error whenever we try to run a report with the report attached. However, the email sends fine if the report is not attached.

Reports can also be exported into different formats without problem when viewing the report through report manager.
I received a email telling me there had been a reply to this thread, but I see nothing.

Can anyone help with this?
|||Did you check the log files to see what the error is?|||Bringing this topic back from the dead a little I know, but I've finally had chance to get back to trying to use this since being switched onto other projects.

Which log would likely contain the information needed.
The logs located at: C:\Program Files\Microsoft SQL Server\MSSQL\LOG
called: SQLAGENT.OUT ?
|||I am having the same problem. The report service log file only re-iterates the message, and does not provide any further details.
I checked the Report Server configuration file and it looks okay, nothing unusual.
Does anyone have any idea what may be causing the problem?|||

The RS log files are located here:

%Program Files%\Microsft SQL Server\MSSQL.2\Reporting Services\LogFiles

The Windows Service log file (which processes subscription events) should have a name like this:

ReportServerService__03_19_2007_00_01_09.log

|||

No entry is made in that folder when it fails the job.

However, we have noticed that if my colleague creates the subscription then it works fine without the error. So I suspect it might be related to permissions in sql server or on the win 2000 server box. So far I've been unable to determine which permission is causing it. Despite ensuring I am in the same permission groups as he is, my subscriptions still fail.

scheduled job status is "performing completion actions"

Any idea what this means. I tried stopping the job and deleting it but I
couldn't do either.
Thanks,
Dan D.
Hi,
by my experiance it usually means that SQL Server Agent is cleaning up
temporary object it has created during execution of job.
Usually it is fast so you cannot see it but sometimes it takes time,
especially if there is a lot of data.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.
|||I forgot to say that it has been that way for over 2 weeks so something must
be wrong. But I can't remove it so I'm not sure what to do about it.
"Danijel Novak" wrote:

> Hi,
> by my experiance it usually means that SQL Server Agent is cleaning up
> temporary object it has created during execution of job.
> Usually it is fast so you cannot see it but sometimes it takes time,
> especially if there is a lot of data.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>
>
|||Dan
What does the job do?
Perhasps you might look at Task Manager to see what happened.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.
|||The job is a dts package that does some inserts, deletes and updates to
various tables.
"Uri Dimant" wrote:

> Dan
> What does the job do?
> Perhasps you might look at Task Manager to see what happened.
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>
>
|||"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> I forgot to say that it has been that way for over 2 weeks so something
must
> be wrong. But I can't remove it so I'm not sure what to do about it.
>
I'll bet you've got it setup to email upon completion and SQL Mail isn't
working.
Tht's when I've generally seen it.
[vbcol=seagreen]
> "Danijel Novak" wrote:
I[vbcol=seagreen]
|||There are no email notifications in the package. And our SQLMail is working.
Every step is an execute sql task.
"Greg D. Moore (Strider)" wrote:

> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> must
> I'll bet you've got it setup to email upon completion and SQL Mail isn't
> working.
> Tht's when I've generally seen it.
>
> I
>
>
|||Hi,
Did you try to restart SQL Server Agent?
Maybe restart could stop the job.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...[vbcol=seagreen]
>I forgot to say that it has been that way for over 2 weeks so something
>must
> be wrong. But I can't remove it so I'm not sure what to do about it.
> "Danijel Novak" wrote:
|||I was finally able to delete the job. I created a new one.
Thanks,
"Danijel Novak" wrote:

> Hi,
> Did you try to restart SQL Server Agent?
> Maybe restart could stop the job.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
>
>

scheduled job status is "performing completion actions"

Any idea what this means. I tried stopping the job and deleting it but I
couldn't do either.
Thanks,
--
Dan D.Hi,
by my experiance it usually means that SQL Server Agent is cleaning up
temporary object it has created during execution of job.
Usually it is fast so you cannot see it but sometimes it takes time,
especially if there is a lot of data.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.|||I forgot to say that it has been that way for over 2 weeks so something must
be wrong. But I can't remove it so I'm not sure what to do about it.
"Danijel Novak" wrote:
> Hi,
> by my experiance it usually means that SQL Server Agent is cleaning up
> temporary object it has created during execution of job.
> Usually it is fast so you cannot see it but sometimes it takes time,
> especially if there is a lot of data.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> > Any idea what this means. I tried stopping the job and deleting it but I
> > couldn't do either.
> >
> > Thanks,
> > --
> > Dan D.
>
>|||Dan
What does the job do?
Perhasps you might look at Task Manager to see what happened.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.|||The job is a dts package that does some inserts, deletes and updates to
various tables.
"Uri Dimant" wrote:
> Dan
> What does the job do?
> Perhasps you might look at Task Manager to see what happened.
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> > Any idea what this means. I tried stopping the job and deleting it but I
> > couldn't do either.
> >
> > Thanks,
> > --
> > Dan D.
>
>|||"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> I forgot to say that it has been that way for over 2 weeks so something
must
> be wrong. But I can't remove it so I'm not sure what to do about it.
>
I'll bet you've got it setup to email upon completion and SQL Mail isn't
working.
Tht's when I've generally seen it.
> "Danijel Novak" wrote:
> > Hi,
> >
> > by my experiance it usually means that SQL Server Agent is cleaning up
> > temporary object it has created during execution of job.
> > Usually it is fast so you cannot see it but sometimes it takes time,
> > especially if there is a lot of data.
> >
> > Danijel
> >
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> > > Any idea what this means. I tried stopping the job and deleting it but
I
> > > couldn't do either.
> > >
> > > Thanks,
> > > --
> > > Dan D.
> >
> >
> >|||There are no email notifications in the package. And our SQLMail is working.
Every step is an execute sql task.
"Greg D. Moore (Strider)" wrote:
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> > I forgot to say that it has been that way for over 2 weeks so something
> must
> > be wrong. But I can't remove it so I'm not sure what to do about it.
> >
> I'll bet you've got it setup to email upon completion and SQL Mail isn't
> working.
> Tht's when I've generally seen it.
>
> > "Danijel Novak" wrote:
> >
> > > Hi,
> > >
> > > by my experiance it usually means that SQL Server Agent is cleaning up
> > > temporary object it has created during execution of job.
> > > Usually it is fast so you cannot see it but sometimes it takes time,
> > > especially if there is a lot of data.
> > >
> > > Danijel
> > >
> > >
> > > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > > news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> > > > Any idea what this means. I tried stopping the job and deleting it but
> I
> > > > couldn't do either.
> > > >
> > > > Thanks,
> > > > --
> > > > Dan D.
> > >
> > >
> > >
>
>|||Hi,
Did you try to restart SQL Server Agent?
Maybe restart could stop the job.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
>I forgot to say that it has been that way for over 2 weeks so something
>must
> be wrong. But I can't remove it so I'm not sure what to do about it.
> "Danijel Novak" wrote:
>> Hi,
>> by my experiance it usually means that SQL Server Agent is cleaning up
>> temporary object it has created during execution of job.
>> Usually it is fast so you cannot see it but sometimes it takes time,
>> especially if there is a lot of data.
>> Danijel
>>
>> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
>> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>> > Any idea what this means. I tried stopping the job and deleting it but
>> > I
>> > couldn't do either.
>> >
>> > Thanks,
>> > --
>> > Dan D.
>>|||I was finally able to delete the job. I created a new one.
Thanks,
"Danijel Novak" wrote:
> Hi,
> Did you try to restart SQL Server Agent?
> Maybe restart could stop the job.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> >I forgot to say that it has been that way for over 2 weeks so something
> >must
> > be wrong. But I can't remove it so I'm not sure what to do about it.
> >
> > "Danijel Novak" wrote:
> >
> >> Hi,
> >>
> >> by my experiance it usually means that SQL Server Agent is cleaning up
> >> temporary object it has created during execution of job.
> >> Usually it is fast so you cannot see it but sometimes it takes time,
> >> especially if there is a lot of data.
> >>
> >> Danijel
> >>
> >>
> >> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> >> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> >> > Any idea what this means. I tried stopping the job and deleting it but
> >> > I
> >> > couldn't do either.
> >> >
> >> > Thanks,
> >> > --
> >> > Dan D.
> >>
> >>
> >>
>
>

scheduled job status is "performing completion actions"

Any idea what this means. I tried stopping the job and deleting it but I
couldn't do either.
Thanks,
--
Dan D.Hi,
by my experiance it usually means that SQL Server Agent is cleaning up
temporary object it has created during execution of job.
Usually it is fast so you cannot see it but sometimes it takes time,
especially if there is a lot of data.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.|||I forgot to say that it has been that way for over 2 weeks so something must
be wrong. But I can't remove it so I'm not sure what to do about it.
"Danijel Novak" wrote:

> Hi,
> by my experiance it usually means that SQL Server Agent is cleaning up
> temporary object it has created during execution of job.
> Usually it is fast so you cannot see it but sometimes it takes time,
> especially if there is a lot of data.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>
>|||Dan
What does the job do?
Perhasps you might look at Task Manager to see what happened.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.|||The job is a dts package that does some inserts, deletes and updates to
various tables.
"Uri Dimant" wrote:

> Dan
> What does the job do?
> Perhasps you might look at Task Manager to see what happened.
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>
>|||"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> I forgot to say that it has been that way for over 2 weeks so something
must
> be wrong. But I can't remove it so I'm not sure what to do about it.
>
I'll bet you've got it setup to email upon completion and SQL Mail isn't
working.
Tht's when I've generally seen it.
[vbcol=seagreen]
> "Danijel Novak" wrote:
>
I[vbcol=seagreen]|||There are no email notifications in the package. And our SQLMail is working.
Every step is an execute sql task.
"Greg D. Moore (Strider)" wrote:

> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> must
> I'll bet you've got it setup to email upon completion and SQL Mail isn't
> working.
> Tht's when I've generally seen it.
>
> I
>
>|||Hi,
Did you try to restart SQL Server Agent?
Maybe restart could stop the job.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...[vbcol=seagreen]
>I forgot to say that it has been that way for over 2 weeks so something
>must
> be wrong. But I can't remove it so I'm not sure what to do about it.
> "Danijel Novak" wrote:
>|||I was finally able to delete the job. I created a new one.
Thanks,
"Danijel Novak" wrote:

> Hi,
> Did you try to restart SQL Server Agent?
> Maybe restart could stop the job.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
>
>

scheduled job control

i'd like to use external vbscript task to check [running] status of
scheduled jobs on sql database, to see is particular job running,
and may it be forced to start or stop.
do i need some special component or is all allready bilt in into sql server?
thanks for comments.Look at sp_help_job in Books Online. It should give you everything you
need.
"sali" <gabor.salai@.tel.net.ba> wrote in message
news:#g43N6AKFHA.1052@.TK2MSFTNGP10.phx.gbl...
> i'd like to use external vbscript task to check [running] status of
> scheduled jobs on sql database, to see is particular job running,
> and may it be forced to start or stop.
> do i need some special component or is all allready bilt in into sql
server?
> thanks for comments.
>
>