Scheduling SSRS reports using an external scheduling package

We use a scheduling package to coordinate the scheduling of our batch
processes on most of our systems. Is there a way to trigger the
running of an SSRS report this way? And, what the specifics of what
is takes with some examples of how and what needs to be interfaced?
Thanks,On Sep 17, 12:49 pm, thill...@.steelcase.com wrote:
> We use a scheduling package to coordinate the scheduling of our batch
> processes on most of our systems. Is there a way to trigger the
> running of an SSRS report this way? And, what the specifics of what
> is takes with some examples of how and what needs to be interfaced?
> Thanks,
You can look into the rs.exe utility. Also, you might want to consider
calling a URL similar to this one to obtain the physical report file
and then attach it to an email. You can do this in ASP.NET (attaching
the file to an email, streaming the report file directly from an
HTTPRequest of the URL below), etc. It's up to you're preference and
expertise.
http://ServerX/reportserver?/Directory/ReportName&rs:Command=Render&Param1=Param1Value&rs:Format=PDF
Format:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Scheduling sqlcmd script in sql agent

Is it possible to schedule a sqlcmd script within sqlagent? That is without running a cmdexec?

Thanks,

what is the actual requirement ... its not clear. you can use XP_cmdshell to execute sqlcmd script from SQL envriornment

Else you can use windows scheduler to execute the sqlcmd script file

Madhu

|||

I was hoping that we could run a sqlcmd script in a normal agent job, similar to the ability to run them in sql management studio window. The advantage of doing that is, the entire solution is in one place.

From your email it sounds as if, there is no way to do this and the only choice is to run a cmdshell agent job or to schedule in the Windows scheduler.

|||

In the Job Step Properties window, in the [General], click on [Type].

There you can select [Operation System ...]

Put your script there.

(

SQLCmd runs SQL commands in the OS environment,

CMDExec runs OS commands in the SQL Server environment -including SQLCmd.exe.

)

However, if you 'should' be able to directly run SQLCmd script as a Job step.

If you posted the command line, we may be able to better advise you about the most efficient method to accomplish your task.

Scheduling Running Of Proc's

Hello, I am trying to figure out the most appropriate means to schedule a
procedure to run at a specified interval during the day.
I see the SQL Server has "SQL Server Agent" which appears to allow you to
schedule jobs to be run at periodic times, but unfortuneately the smallest
interval that I can find is every hour and I was looking to schedule this to
run every few minutes. What other means is available to me to schdeule the
procedure to run every few minutes?
I did play around with the "SQL Server Agent" and the scheduling seems to work
just fine, but the email notification never occurs. The message that I
located for why the email notification did not occur is as follows "The job
succeeded. The Job was invoked by Schedule 1 (MyFirstSchedule). The last
step to run was step 1 (First Step). NOTE: Failed to notify 'JimHeavey' via
network popup. NOTE: Failed to notify 'JimHeavey' via email."
What do I not have set up correctly to cause the email notification not to
occur?
Thanks in advance for your assistance!!!!!!!!!!You can schedule a job to run every minute if you want. Does your SQL mail
work outside of jobs? If you go into operators and try to send a test email,
it is successful?
Also, is your SQL server on a different subnet that where you are logged in?
Perhaps the routers are blocking the type of traffic that is produced by the
net send's (network popup's)
To test this you could go on the server and type in a command prompt, "net
send yourloginname hello" and see if it pops up on your screen.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Jim Heavey" <Annomous@.hotmail.com> wrote in message
news:O8v7OkumDHA.2772@.TK2MSFTNGP12.phx.gbl...
> Hello, I am trying to figure out the most appropriate means to schedule a
> procedure to run at a specified interval during the day.
> I see the SQL Server has "SQL Server Agent" which appears to allow you to
> schedule jobs to be run at periodic times, but unfortuneately the smallest
> interval that I can find is every hour and I was looking to schedule this
to
> run every few minutes. What other means is available to me to schdeule
the
> procedure to run every few minutes?
> I did play around with the "SQL Server Agent" and the scheduling seems to
work
> just fine, but the email notification never occurs. The message that I
> located for why the email notification did not occur is as follows "The
job
> succeeded. The Job was invoked by Schedule 1 (MyFirstSchedule). The last
> step to run was step 1 (First Step). NOTE: Failed to notify 'JimHeavey'
via
> network popup. NOTE: Failed to notify 'JimHeavey' via email."
> What do I not have set up correctly to cause the email notification not to
> occur?
> Thanks in advance for your assistance!!!!!!!!!!
>
>
>|||OK how do you configure the job to run every minute?
I am running the MSDE version of SQL server and I have gotten all of the tools
from an accedemic version of the software from school. It would not load the
full version of the product on my XP machine for some reason. But to me it
looks like full blown version of SQL server.
I have run anything through "SQL mail". Does this have to be configure for
the mail feature to work for job scheduling? Did not seem to mind going
through the script. How do I go about setting that up?
"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:OzojzxumDHA.2820@.TK2MSFTNGP10.phx.gbl...
> You can schedule a job to run every minute if you want. Does your SQL mail
> work outside of jobs? If you go into operators and try to send a test email,
> it is successful?
> Also, is your SQL server on a different subnet that where you are logged in?
> Perhaps the routers are blocking the type of traffic that is produced by the
> net send's (network popup's)
> To test this you could go on the server and type in a command prompt, "net
> send yourloginname hello" and see if it pops up on your screen.
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Jim Heavey" <Annomous@.hotmail.com> wrote in message
> news:O8v7OkumDHA.2772@.TK2MSFTNGP12.phx.gbl...
> > Hello, I am trying to figure out the most appropriate means to schedule a
> > procedure to run at a specified interval during the day.
> >
> > I see the SQL Server has "SQL Server Agent" which appears to allow you to
> > schedule jobs to be run at periodic times, but unfortuneately the smallest
> > interval that I can find is every hour and I was looking to schedule this
> to
> > run every few minutes. What other means is available to me to schdeule
> the
> > procedure to run every few minutes?
> >
> > I did play around with the "SQL Server Agent" and the scheduling seems to
> work
> > just fine, but the email notification never occurs. The message that I
> > located for why the email notification did not occur is as follows "The
> job
> > succeeded. The Job was invoked by Schedule 1 (MyFirstSchedule). The last
> > step to run was step 1 (First Step). NOTE: Failed to notify 'JimHeavey'
> via
> > network popup. NOTE: Failed to notify 'JimHeavey' via email."
> >
> > What do I not have set up correctly to cause the email notification not to
> > occur?
> >
> > Thanks in advance for your assistance!!!!!!!!!!
> >
> >
> >
> >
> >
>

Scheduling an SSIS package that invokes a web service

Hey,

I have an SSIS package that invokes a web service and then updates a table. It runs fine as long as I am running it on the local machine. However, as soon as I save this package to the sql server, and try to schedule this as a job, it starts to fail. Now, the web service writes to an xml file and also uses an xsd and and an xsl file. When I save a dts package to the sql server, whats the proper way of referencing these files? I think this probably is what is making the package to fail, ut I am not sure.

Any help is greatly appreciated!!

Thanks!

You should use a configuration (right-click in the package and choose configurations) to set the ConnectionString property of the connection managers for the files. Or you could use expressions to set the connection strings (paths and filenames) based on variables. The variables can be set at runtime using the /SET option of DTEXEC.|||Also make sure you've configured SSIS logging, so you can find out why the package fails now or (once you fix the problem and go to production) if something goes wrong with scheduled package in production.|||That depends on where you want to keep them. I prefer to keep them in files on the disk. If your package is in SQL and you prefer to avoid the disk entirely, you can keep them in the database and just load them into variables via the Execute SQL task. The XML task and the XML Source component support receiving the XSD/XSLT from variables.
|||Thanks a lot for the suggestions. I will try them out and see how it works.|||

Hey,

Sorry for this delayed reply. Since I posted this question a lot of issues cropped up with my SQL server which eventually led to a total reinstallation of all apps on my pc. Anyway, I discovered that the problem I have been having was because of permission issues. I was able to fix that problem and just when I thought that I had everything going, I came across a new problem. After I save the SSIS package in sql server and create a job, the job starts failing. This is the error that I am getting:

-1073548540,0x,An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: Unable to connect to the remote server.

Any suggestions would be very helpful.

Thanks!

|||Could it be a authentication issue? Is there any security on the web service?|||

Guys!!Thanks a lot for all the suggestions. Really appreciate your help. Problem was a combination of many issues. One was related to 32bit/64bit differences, the other was authentication, and finally some syntax problems when invoking the web service. Seems it is working really well now.

Thanks again!

Scheduling a query to be executed at given time in SQL Server 2005

Hi friend!

I want to schedule a query or procedure running at given time regularly eg: at 12AM daily. Please tell me how to do that in sql server 2005.

We use SQL server 2005 developer edition.

Thanks in advance.

SS2005 has a scheduller, SS Agent. Make sure it is installed and the service is up and running. You can get access to it through SSManagement Studio. BTW, this is a SSIS forum; if you have further question I will move this thread to a more appropiate forum.

Scheduling a query at regular intervals in sql server 2005

Hi friend!

I want to schedule a query or procedure running at regular intervals eg.@. 12AM on everyday. Please help me to do this in SQL server 2005

Thanks/Regards

Antony S

There are 3 choices I can think of off the top of my head;

1/ Use SQL Agent (not available in express) and create a T-SQL job.

2/ Use the windows task scheduler to call SQLCMD and then have it call a .sql file with your code in it.

3/ Use a service broker timer.

|||Books online reference http://msdn2.microsoft.com/en-us/library/ms191439.aspx|||Create a SQL Job and a schedule inside of the job to run everyday at 12am. Make sure that SQLAgent is enabled.sql

Scheduling a job under SA

I've shceduled a job under sa account (I've changed the password
though),this job access local folder of the box running SQL server.I have
added sa to the sysadmin role and it dose have access to the local folder
..How is it possible as *sa* is a sql server account and how it has the
enough permissions to access local file system?
Thanks a lot
If the job is owned by a sysadmin, it's operating under the
security context of the service account for SQL Agent.
-Sue
On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
wrote:

>I've shceduled a job under sa account (I've changed the password
>though),this job access local folder of the box running SQL server.I have
>added sa to the sysadmin role and it dose have access to the local folder
>.How is it possible as *sa* is a sql server account and how it has the
>enough permissions to access local file system?
>Thanks a lot
>
|||Thanks a lot
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:e36gf11g82of53tigjia7dqobotkfvp5pt@.4ax.com...
> If the job is owned by a sysadmin, it's operating under the
> security context of the service account for SQL Agent.
> -Sue
> On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
> wrote:
>

Scheduling a job under SA

I've shceduled a job under sa account (I've changed the password
though),this job access local folder of the box running SQL server.I have
added sa to the sysadmin role and it dose have access to the local folder
.How is it possible as *sa* is a sql server account and how it has the
enough permissions to access local file system?
Thanks a lotIf the job is owned by a sysadmin, it's operating under the
security context of the service account for SQL Agent.
-Sue
On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
wrote:

>I've shceduled a job under sa account (I've changed the password
>though),this job access local folder of the box running SQL server.I have
>added sa to the sysadmin role and it dose have access to the local folder
>.How is it possible as *sa* is a sql server account and how it has the
>enough permissions to access local file system?
>Thanks a lot
>|||Thanks a lot
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:e36gf11g82of53tigjia7dqobotkfvp5pt@.
4ax.com...
> If the job is owned by a sysadmin, it's operating under the
> security context of the service account for SQL Agent.
> -Sue
> On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
> wrote:
>
>

Scheduling a job under SA

I've shceduled a job under sa account (I've changed the password
though:)),this job access local folder of the box running SQL server.I have
added sa to the sysadmin role and it dose have access to the local folder
.How is it possible as *sa* is a sql server account and how it has the
enough permissions to access local file system?
Thanks a lotIf the job is owned by a sysadmin, it's operating under the
security context of the service account for SQL Agent.
-Sue
On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
wrote:
>I've shceduled a job under sa account (I've changed the password
>though:)),this job access local folder of the box running SQL server.I have
>added sa to the sysadmin role and it dose have access to the local folder
>.How is it possible as *sa* is a sql server account and how it has the
>enough permissions to access local file system?
>Thanks a lot
>|||Thanks a lot
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:e36gf11g82of53tigjia7dqobotkfvp5pt@.4ax.com...
> If the job is owned by a sysadmin, it's operating under the
> security context of the service account for SQL Agent.
> -Sue
> On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
> wrote:
>>I've shceduled a job under sa account (I've changed the password
>>though:)),this job access local folder of the box running SQL server.I
>>have
>>added sa to the sysadmin role and it dose have access to the local folder
>>.How is it possible as *sa* is a sql server account and how it has the
>>enough permissions to access local file system?
>>Thanks a lot
>sql

Scheduler appears to be hung

Hi,
I have a SQL Server 2000 SP3 running on Windows Server 2000. I have moved
two databases that are used continously about two months back to this server
and since then I have noticed this error coming up every 10 to 15 days.
The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
Error: 17883, Severity: 1, State: 0
The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x0233C8D8.
Error: 17883, Severity: 1, State: 0
The SQL Server just freezes and becomes non-responsive. The above error was
present for almost 8 minutes before it started responding. At one time, I
wasn't even able to do a Remote Desktop to the server to check why the server
is not responding and later on I found that it had the same error. Any
information regarding this will be highly appreciated.How many processors do you have running? This implies two, or at least one
with hyperthreading. You might try turning one off completely.
"sharman" wrote:
> Hi,
> I have a SQL Server 2000 SP3 running on Windows Server 2000. I have moved
> two databases that are used continously about two months back to this server
> and since then I have noticed this error coming up every 10 to 15 days.
> The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
> Error: 17883, Severity: 1, State: 0
> The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x0233C8D8.
> Error: 17883, Severity: 1, State: 0
> The SQL Server just freezes and becomes non-responsive. The above error was
> present for almost 8 minutes before it started responding. At one time, I
> wasn't even able to do a Remote Desktop to the server to check why the server
> is not responding and later on I found that it had the same error. Any
> information regarding this will be highly appreciated.|||For starters, just set SQL Server to use a single processor under the
instance properties. Also, you might want to apply SP4...
"sharman" wrote:
> Thanks for the information. It has 2 processors. How do I turn off
> hyperthreading and what are the implications of turning it off? Thanks.
> "James Luetkehoelter" wrote:
> > How many processors do you have running? This implies two, or at least one
> > with hyperthreading. You might try turning one off completely.
> >
> > "sharman" wrote:
> >
> > > Hi,
> > >
> > > I have a SQL Server 2000 SP3 running on Windows Server 2000. I have moved
> > > two databases that are used continously about two months back to this server
> > > and since then I have noticed this error coming up every 10 to 15 days.
> > >
> > > The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
> > > Error: 17883, Severity: 1, State: 0
> > > The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x0233C8D8.
> > > Error: 17883, Severity: 1, State: 0
> > >
> > > The SQL Server just freezes and becomes non-responsive. The above error was
> > > present for almost 8 minutes before it started responding. At one time, I
> > > wasn't even able to do a Remote Desktop to the server to check why the server
> > > is not responding and later on I found that it had the same error. Any
> > > information regarding this will be highly appreciated.|||Thanks for the information. It has 2 processors. How do I turn off
hyperthreading and what are the implications of turning it off? Thanks.
"James Luetkehoelter" wrote:
> How many processors do you have running? This implies two, or at least one
> with hyperthreading. You might try turning one off completely.
> "sharman" wrote:
> > Hi,
> >
> > I have a SQL Server 2000 SP3 running on Windows Server 2000. I have moved
> > two databases that are used continously about two months back to this server
> > and since then I have noticed this error coming up every 10 to 15 days.
> >
> > The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
> > Error: 17883, Severity: 1, State: 0
> > The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x0233C8D8.
> > Error: 17883, Severity: 1, State: 0
> >
> > The SQL Server just freezes and becomes non-responsive. The above error was
> > present for almost 8 minutes before it started responding. At one time, I
> > wasn't even able to do a Remote Desktop to the server to check why the server
> > is not responding and later on I found that it had the same error. Any
> > information regarding this will be highly appreciated.|||Hyperthreading can be diabled at the BIOS level. Most database applications
will experience an increase in performance with HT disabled. Test in your
environment.
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:0AEF20A0-A529-42BE-888B-C86BD6957F88@.microsoft.com...
> Thanks for the information. It has 2 processors. How do I turn off
> hyperthreading and what are the implications of turning it off? Thanks.
> "James Luetkehoelter" wrote:
>> How many processors do you have running? This implies two, or at least
>> one
>> with hyperthreading. You might try turning one off completely.
>> "sharman" wrote:
>> > Hi,
>> >
>> > I have a SQL Server 2000 SP3 running on Windows Server 2000. I have
>> > moved
>> > two databases that are used continously about two months back to this
>> > server
>> > and since then I have noticed this error coming up every 10 to 15 days.
>> >
>> > The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context
>> > 0x023339C0.
>> > Error: 17883, Severity: 1, State: 0
>> > The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context
>> > 0x0233C8D8.
>> > Error: 17883, Severity: 1, State: 0
>> >
>> > The SQL Server just freezes and becomes non-responsive. The above error
>> > was
>> > present for almost 8 minutes before it started responding. At one time,
>> > I
>> > wasn't even able to do a Remote Desktop to the server to check why the
>> > server
>> > is not responding and later on I found that it had the same error. Any
>> > information regarding this will be highly appreciated.|||Take a look at this excellent MS whitepaper:
http://www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx
Linchi
"sharman" wrote:
> Hi,
> I have a SQL Server 2000 SP3 running on Windows Server 2000. I have moved
> two databases that are used continously about two months back to this server
> and since then I have noticed this error coming up every 10 to 15 days.
> The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
> Error: 17883, Severity: 1, State: 0
> The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x0233C8D8.
> Error: 17883, Severity: 1, State: 0
> The SQL Server just freezes and becomes non-responsive. The above error was
> present for almost 8 minutes before it started responding. At one time, I
> wasn't even able to do a Remote Desktop to the server to check why the server
> is not responding and later on I found that it had the same error. Any
> information regarding this will be highly appreciated.

Scheduled Stored Procedure Causes SQL Server to stop responding.

Hi,
We have a scheduled stored procedure running on SQL Server (enterprise
server I believe). This stored proc is one of a set of procs run by one
job, it takes about 11 minutes to do everything.
Sometimes, during the execution of the Job, the server seems to not
respond to connection requests from our website, giving the following
error:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
I didn't think that running a stored procedure (even if it is a bit of a
beast) would bring down SQL server. Does anyone have any idea what we
are doing wrong?
Thanks for your help & time,
Austin Rathe
*** Sent via Developersdex http://www.codecomments.com ***
Can you use performance monitor to see what actually is happening to the
system when that stored proc was running? Check to see if the CPU is maxing
out or the disks are being thrashed? May be there's scope for optimising
that stored proc. Could you post the code?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Austin Rathe" <austin#REMOVETHIS#@.gametart.com> wrote in message
news:O3Fkl8WfFHA.3316@.TK2MSFTNGP14.phx.gbl...
Hi,
We have a scheduled stored procedure running on SQL Server (enterprise
server I believe). This stored proc is one of a set of procs run by one
job, it takes about 11 minutes to do everything.
Sometimes, during the execution of the Job, the server seems to not
respond to connection requests from our website, giving the following
error:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
I didn't think that running a stored procedure (even if it is a bit of a
beast) would bring down SQL server. Does anyone have any idea what we
are doing wrong?
Thanks for your help & time,
Austin Rathe
*** Sent via Developersdex http://www.codecomments.com ***
sql

Scheduled Stored Procedure Causes SQL Server to stop responding.

Hi,
We have a scheduled stored procedure running on SQL Server (enterprise
server I believe). This stored proc is one of a set of procs run by one
job, it takes about 11 minutes to do everything.
Sometimes, during the execution of the Job, the server seems to not
respond to connection requests from our website, giving the following
error:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
I didn't think that running a stored procedure (even if it is a bit of a
beast) would bring down SQL server. Does anyone have any idea what we
are doing wrong?
Thanks for your help & time,
Austin Rathe
*** Sent via Developersdex http://www.developersdex.com ***Can you use performance monitor to see what actually is happening to the
system when that stored proc was running? Check to see if the CPU is maxing
out or the disks are being thrashed? May be there's scope for optimising
that stored proc. Could you post the code?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Austin Rathe" <austin#REMOVETHIS#@.gametart.com> wrote in message
news:O3Fkl8WfFHA.3316@.TK2MSFTNGP14.phx.gbl...
Hi,
We have a scheduled stored procedure running on SQL Server (enterprise
server I believe). This stored proc is one of a set of procs run by one
job, it takes about 11 minutes to do everything.
Sometimes, during the execution of the Job, the server seems to not
respond to connection requests from our website, giving the following
error:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
I didn't think that running a stored procedure (even if it is a bit of a
beast) would bring down SQL server. Does anyone have any idea what we
are doing wrong?
Thanks for your help & time,
Austin Rathe
*** Sent via Developersdex http://www.developersdex.com ***

Scheduled Stored Procedure Causes SQL Server to stop responding.

Hi,
We have a scheduled stored procedure running on SQL Server (enterprise
server I believe). This stored proc is one of a set of procs run by one
job, it takes about 11 minutes to do everything.
Sometimes, during the execution of the Job, the server seems to not
respond to connection requests from our website, giving the following
error:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
I didn't think that running a stored procedure (even if it is a bit of a
beast) would bring down SQL server. Does anyone have any idea what we
are doing wrong?
Thanks for your help & time,
Austin Rathe
*** Sent via Developersdex http://www.codecomments.com ***Can you use performance monitor to see what actually is happening to the
system when that stored proc was running? Check to see if the CPU is maxing
out or the disks are being thrashed? May be there's scope for optimising
that stored proc. Could you post the code?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Austin Rathe" <austin#REMOVETHIS#@.gametart.com> wrote in message
news:O3Fkl8WfFHA.3316@.TK2MSFTNGP14.phx.gbl...
Hi,
We have a scheduled stored procedure running on SQL Server (enterprise
server I believe). This stored proc is one of a set of procs run by one
job, it takes about 11 minutes to do everything.
Sometimes, during the execution of the Job, the server seems to not
respond to connection requests from our website, giving the following
error:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
I didn't think that running a stored procedure (even if it is a bit of a
beast) would bring down SQL server. Does anyone have any idea what we
are doing wrong?
Thanks for your help & time,
Austin Rathe
*** Sent via Developersdex http://www.codecomments.com ***

Scheduled reports not running

Hi
We having problems running our scheduled reports.
A domain admin had originally scheduled them under her network username
which as i said had domain admin rights. Those domain rights where taken away
from her username and then we created a sql user name to run the report,
since then the scheduled reports do not run and not quite sure where to look.
Reporting the username on sql has accessadmin rights and public rights on
the reporting databases, does anyone have an inkling of what might be going
on?
I have checked the log but it doesn't give any errors it just says this
aspnet_wp!library!1dc!10/21/2005-08:14:33:: i INFO: Call to
GetPermissions:/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!library!1dc!10/21/2005-08:14:33:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!1dc!10/21/2005-08:14:34:: i INFO: Call to RenderFirst(
'/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:14:34:: i INFO: From cache live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!library!1dc!10/21/2005-08:14:34:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!1dc!10/21/2005-08:14:34:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:14:34:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:14:45:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:14:45:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:14:45:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:14:48:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:14:48:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:49:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:49:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:14:49:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:14:49:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:14:53:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:14:53:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:14:53:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:14:57:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:14:57:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:14:57:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:15:00:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:15:00:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:15:00:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:15:04:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:15:04:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:15:04:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:15:08:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:15:08:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:15:08:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
aspnet_wp!library!1dc!10/21/2005-08:15:18:: i INFO: Call to RenderNext( '/IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Session live: /IT
Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Item not cacheable: -
ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
aspnet_wp!webserver!1dc!10/21/2005-08:15:18:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
aspnet_wp!webserver!1dc!10/21/2005-08:15:18:: i INFO: Processed report.
Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
Stream='9094a702-e16d-408c-912d-1842e95d3820'
basically it looks as though the report has run' but i know it hasn't.Did you check all three logs, keep in mind there may be multiple logs for the
same day:
- ReportServerWebApp
- ReportServerService
- ReportServer
Are there any errors in any of these at the time the subscription was
supposed to run?
Also, does the log on account running the ReportServer service a Domain
Admin account? It needs to be able to look up account credentials for RS
users on your network.
And, is your ReportServer instance configured to work with Windows
authentication, SQL Authentication or both?
Thanks.
bhc
"Vanessa" wrote:
> Hi
> We having problems running our scheduled reports.
> A domain admin had originally scheduled them under her network username
> which as i said had domain admin rights. Those domain rights where taken away
> from her username and then we created a sql user name to run the report,
> since then the scheduled reports do not run and not quite sure where to look.
> Reporting the username on sql has accessadmin rights and public rights on
> the reporting databases, does anyone have an inkling of what might be going
> on?
> I have checked the log but it doesn't give any errors it just says this
>
> aspnet_wp!library!1dc!10/21/2005-08:14:33:: i INFO: Call to
> GetPermissions:/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!library!1dc!10/21/2005-08:14:33:: i INFO: Call to
> GetSystemPermissions
> aspnet_wp!library!1dc!10/21/2005-08:14:34:: i INFO: Call to RenderFirst(
> '/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:14:34:: i INFO: From cache live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!library!1dc!10/21/2005-08:14:34:: i INFO: Initializing
> EnableExecutionLogging to 'True' as specified in Server system properties.
> aspnet_wp!webserver!1dc!10/21/2005-08:14:34:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:14:34:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:14:45:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:45:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:14:45:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:14:45:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:14:48:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:14:48:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:49:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:49:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:14:49:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:14:49:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:14:53:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:53:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:14:53:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:14:53:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:14:57:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:14:57:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:14:57:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:14:57:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:15:00:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:00:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:15:00:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:15:00:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:15:04:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:04:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:15:04:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:15:04:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:15:08:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:08:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:15:08:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:15:08:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> aspnet_wp!library!1dc!10/21/2005-08:15:18:: i INFO: Call to RenderNext( '/IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target' )
> aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Session live: /IT
> Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!cache!1dc!10/21/2005-08:15:18:: i INFO: Item not cacheable: -
> ShowHideToggle /IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target
> aspnet_wp!webserver!1dc!10/21/2005-08:15:18:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target', Stream=''
> aspnet_wp!webserver!1dc!10/21/2005-08:15:18:: i INFO: Processed report.
> Report='/IT Helpdesk/IT_IT_Helpdesk_Trend_Opencall and Target',
> Stream='9094a702-e16d-408c-912d-1842e95d3820'
> basically it looks as though the report has run' but i know it hasn't.
>

Scheduled Reports Not Being Sent Out

I have several scheduled reports that have been running every morning and being emailed out to many recipients. One day it all stopped. There are no error messages. It just doesn't work any more.

I have tried re-deploying them to the report server and rescheduling the jobs but they still don't run.

There are no error messages in the Reporting services log?

Is this RS 2005? I had a problem recently with the SMTP server name specified in the RS Config Tool, I had to use the IP address of the SMTP server rather than the name of it and it fixed the problem. It was something to do with a DNS issue we had.

Might be worth a try.

|||

Hi,

Same problem I have now as you had, I wonder how did you solve your problem.

Please advise,

Frank

|||There has to be some information in the error log of SQL Server Reporting services (stack trace or an informal message). Please post that here.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||All subscription schedules become SQL Agent jobs. You should look in SQL Agent to see if there is an issue with the jobs firing.

Scheduled report printing?

Hi,
We are running SQL Server 2000 and would like to have a series of reports
print out each morning without user intervention. What would be the best
way to accomplish this? If this is not the correct news group for this type
of question please direct me to the correct one.
Thanks in advance,
LinnThanks Igor, that's an interesting article. Too bad I don't have Visual
Studio, or Reporting Services for that matter. I also just noticed that the
article is for SQL Server 2005, we are using SQL Server 2000 still, wonder
if it would work for our version too.
I wonder if a third party software package like Crystal Reports would offer
this option?
Thanks,
Linn
"Igor Taranov -- MSFT" <IgorTaranovMSFT@.discussions.microsoft.com> wrote in
message news:888959B3-CAFB-4122-9F07-3070B15C13B4@.microsoft.com...
> See http://msdn2.microsoft.com/en-us/library/ms160778.aspx
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Linn Kubler" wrote:
>> Hi,
>> We are running SQL Server 2000 and would like to have a series of reports
>> print out each morning without user intervention. What would be the best
>> way to accomplish this? If this is not the correct news group for this
>> type
>> of question please direct me to the correct one.
>> Thanks in advance,
>> Linn
>>|||Has anyone actually got the Sample Printer Delivery Extension to work on a
Reporting Server?
"Igor Taranov -- MSFT" wrote:
> Linn,
> SQL Server Reporting Services 2005 can be installed on SQL 2000, and printer
> delivery should work fine.
> -Igor
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Linn Kubler" wrote:
> > Thanks Igor, that's an interesting article. Too bad I don't have Visual
> > Studio, or Reporting Services for that matter. I also just noticed that the
> > article is for SQL Server 2005, we are using SQL Server 2000 still, wonder
> > if it would work for our version too.
> >
> > I wonder if a third party software package like Crystal Reports would offer
> > this option?
> >
> > Thanks,
> > Linn
> >
> > "Igor Taranov -- MSFT" <IgorTaranovMSFT@.discussions.microsoft.com> wrote in
> > message news:888959B3-CAFB-4122-9F07-3070B15C13B4@.microsoft.com...
> > > See http://msdn2.microsoft.com/en-us/library/ms160778.aspx
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >
> > >
> > > "Linn Kubler" wrote:
> > >
> > >> Hi,
> > >>
> > >> We are running SQL Server 2000 and would like to have a series of reports
> > >> print out each morning without user intervention. What would be the best
> > >> way to accomplish this? If this is not the correct news group for this
> > >> type
> > >> of question please direct me to the correct one.
> > >>
> > >> Thanks in advance,
> > >> Linn
> > >>
> > >>
> > >>
> >
> >
> >

Scheduled package failed but still shows as running job

i had scheduled to run a package it failed but a part of the package still shows up on the integration system running packages. i tried to stop it or delete it nothing works. when i try toi run the package even in visual studio that part of the package fails.

how do i remove the running package?

Thanks

jas

Have you clicked Refresh in Management Studio? The list of running packages does not auto-refresh.|||

Thanks for the reply.

I tried refreshing nothing worked....but anyway i tried shuting down the sql server and bring it again it worked.

The wierd thing was, when it was hanging it was not even able to execute it in my designer.

Thanks again

jas

Scheduled Notifications

Hi , I'm having one code for Scheduled Notification services, it's running without errors but there is no output

<SubscriptionClasses>
<SubscriptionClass>
<SubscriptionClassName>ScheduledSubscriptions</SubscriptionClassName>
<Schema>
<Field>
<FieldName>DeviceName</FieldName>
<FieldType>nvarchar(255)</FieldType>
</Field>
<Field>
<FieldName>SubscriberLocale</FieldName>
<FieldType>nvarchar(5)</FieldType>
</Field>
<Field>
<FieldName>Prescriptionid</FieldName>
<FieldType>int</FieldType>
</Field>
<Field>
<FieldName>status</FieldName>
<FieldType>nvarchar(50)</FieldType>
</Field>
</Schema>
<FileGroup>DEFAULT</FileGroup>
<ScheduledRules>
<ScheduledRule>
<RuleName>ScheduledSubscriptionsRule</RuleName>
<Action>

INSERT INTO SchedPrescriptionNotifications
( SubscriberId,DeviceName,SubscriberLocale,Prescriptionid,status )
SELECT S.SubscriberId, S.DeviceName,
S.SubscriberLocale, C.Prescriptionid, C.status
FROM SchedPrescriptionSubscriptions S , ScheduledEventsChron C
WHERE C.Prescriptionid= S.Prescriptionid
AND C.status = S.status

INSERT SchedSubscriptionChron
(SubscriberId, Prescriptionid, status)
SELECT S.SubscriberId, S.Prescriptionid, C.status
FROM SchedPrescriptionSubscriptions S JOIN ScheduledEventsChron C
ON S.Prescriptionid= C.Prescriptionid
</Action>
<ActionTimeout>PT30M</ActionTimeout>
</ScheduledRule>
</ScheduledRules>
</SubscriptionClass>
</SubscriptionClasses>
and

my C#.net coding is

if (nsSubscription.HasTimedRule)

{

nsSubscription.ScheduleRecurrence = "FREQ=DAILY;";

nsSubscription.ScheduleStart="20070326T072720";

}

i need to know whther the format of Schedulestart property is correct...

Hi , I'm having one code for Scheduled Notification services, it's running without errors but i don't get any output

<SubscriptionClasses>
<SubscriptionClass>
<SubscriptionClassName>ScheduledSubscriptions</SubscriptionClassName>
<Schema>
<Field>
<FieldName>DeviceName</FieldName>
<FieldType>nvarchar(255)</FieldType>
</Field>
<Field>
<FieldName>SubscriberLocale</FieldName>
<FieldType>nvarchar(5)</FieldType>
</Field>
<Field>
<FieldName>Prescriptionid</FieldName>
<FieldType>int</FieldType>
</Field>
<Field>
<FieldName>status</FieldName>
<FieldType>nvarchar(50)</FieldType>
</Field>
</Schema>
<FileGroup>DEFAULT</FileGroup>
<ScheduledRules>
<ScheduledRule>
<RuleName>ScheduledSubscriptionsRule</RuleName>
<Action>

INSERT INTO SchedPrescriptionNotifications
( SubscriberId,DeviceName,SubscriberLocale,Prescriptionid,status )
SELECT S.SubscriberId, S.DeviceName,
S.SubscriberLocale, C.Prescriptionid, C.status
FROM SchedPrescriptionSubscriptions S , ScheduledEventsChron C
WHERE C.Prescriptionid= S.Prescriptionid
AND C.status = S.status

INSERT SchedSubscriptionChron
(SubscriberId, Prescriptionid, status)
SELECT S.SubscriberId, S.Prescriptionid, C.status
FROM SchedPrescriptionSubscriptions S JOIN ScheduledEventsChron C
ON S.Prescriptionid= C.Prescriptionid
</Action>
<ActionTimeout>PT30M</ActionTimeout>
</ScheduledRule>
</ScheduledRules>
</SubscriptionClass>
</SubscriptionClasses>
and

my C#.net coding is

if (nsSubscription.HasTimedRule)

{

nsSubscription.ScheduleRecurrence = "FREQ=DAILY;";

nsSubscription.ScheduleStart="20070326T072720";

}

i need to know whther the format of ScheduleStart property is correct...

|||Hi Subathra -

Here's a link that may help. Look at the timezone component.

http://msdn2.microsoft.com/en-us/library/ms171385.aspx

I'm not sure I follow the match rule logic so I cannot comment on that part. You can do more investigation by looking into the underlying tables to see if notifications were actually produced but just not delivered.

HTH...

Joe

SCheduled Jobs

Hi All,
I have many scheduled jobs running that creates a centralized database from
20 different databases in 20 different locations.
The jobs say they were successful, but the information is not coming over
all the time. If I manually run the job in EM, it works fine. Some of the
jobs call Stored Procedures and others are DTS packages. The jobs that call
SP's have between 3 and 20 steps in them, I check each job and all steps say
they were successful.
The DTS packages delete from the destination table and insert all records
from the Source. The DTS can have up to 4 tables being transferred.
TIA,
JoeHi
It is hard to say from your description what is wrong. Adding extra debug to
your processes may help and making sure that you are checking the error
status correctly in the stored procedures may show some unexpected events.
You may also want to profile the process to view what is really being
executed. Loading the data into separate staging table will allow you to
analyse the data that has been imported.
John
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:3817E52C-788E-4AEA-96A6-11E701AA44B3@.microsoft.com...
> Hi All,
> I have many scheduled jobs running that creates a centralized database
> from
> 20 different databases in 20 different locations.
> The jobs say they were successful, but the information is not coming over
> all the time. If I manually run the job in EM, it works fine. Some of
> the
> jobs call Stored Procedures and others are DTS packages. The jobs that
> call
> SP's have between 3 and 20 steps in them, I check each job and all steps
> say
> they were successful.
> The DTS packages delete from the destination table and insert all records
> from the Source. The DTS can have up to 4 tables being transferred.
> TIA,
> Joe
>

Scheduled JobFailed

Hi,
I scheduled to run a SP which uses XP_SMTP_SENDMAIL. I
have both MSSQLSERVER and MS SQL Agent running on system
account. The server is in a different domain and the mail
server is in different domain.
When I run the SP in QA, it runs without any error. But on
scheduling, it gives the following error:
"The Job failed. The job was invoked by User sa. The last
step to run was step 1 (mail task)."
Was it a problem of startup account?
TIA,
HariYou need to check out the output file for the jobstep (and first define such, of course). Here you
can fine the error message created. "It failed" doesn't tell us anything...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:05c201c39c78$09491960$a601280a@.phx.gbl...
> Hi,
> I scheduled to run a SP which uses XP_SMTP_SENDMAIL. I
> have both MSSQLSERVER and MS SQL Agent running on system
> account. The server is in a different domain and the mail
> server is in different domain.
> When I run the SP in QA, it runs without any error. But on
> scheduling, it gives the following error:
> "The Job failed. The job was invoked by User sa. The last
> step to run was step 1 (mail task)."
> Was it a problem of startup account?
> TIA,
> Hari
>|||Thanks.
I had used RAISERROR inside SP which uses
XP_SMTP_SENDMAIL. When I removed that code, the job
completed successfully.
>--Original Message--
>You need to check out the output file for the jobstep
(and first define such, of course). Here you
>can fine the error message created. "It failed" doesn't
tell us anything...
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Hari" <anonymous@.discussions.microsoft.com> wrote in
message
>news:05c201c39c78$09491960$a601280a@.phx.gbl...
>> Hi,
>> I scheduled to run a SP which uses XP_SMTP_SENDMAIL. I
>> have both MSSQLSERVER and MS SQL Agent running on system
>> account. The server is in a different domain and the
mail
>> server is in different domain.
>> When I run the SP in QA, it runs without any error. But
on
>> scheduling, it gives the following error:
>> "The Job failed. The job was invoked by User sa. The
last
>> step to run was step 1 (mail task)."
>> Was it a problem of startup account?
>> TIA,
>> Hari
>>
>
>.
>|||Yes, an error with severity level > 10 makes the job fail. If you only want to write to the
eventlog, you can use xp_logevent.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hari" <anonymous@.discussions.microsoft.com> wrote in message
news:063f01c39c7f$14d81130$a501280a@.phx.gbl...
> Thanks.
> I had used RAISERROR inside SP which uses
> XP_SMTP_SENDMAIL. When I removed that code, the job
> completed successfully.
>
> >--Original Message--
> >You need to check out the output file for the jobstep
> (and first define such, of course). Here you
> >can fine the error message created. "It failed" doesn't
> tell us anything...
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Hari" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:05c201c39c78$09491960$a601280a@.phx.gbl...
> >> Hi,
> >>
> >> I scheduled to run a SP which uses XP_SMTP_SENDMAIL. I
> >> have both MSSQLSERVER and MS SQL Agent running on system
> >> account. The server is in a different domain and the
> mail
> >> server is in different domain.
> >>
> >> When I run the SP in QA, it runs without any error. But
> on
> >> scheduling, it gives the following error:
> >>
> >> "The Job failed. The job was invoked by User sa. The
> last
> >> step to run was step 1 (mail task)."
> >>
> >> Was it a problem of startup account?
> >>
> >> TIA,
> >> Hari
> >>
> >>
> >
> >
> >.
> >