Scheduling an sp

Hi All,
I hope I can explain this well.
I have an sp that populates certain tables with historical data and I've
scheduled
a job (using EM) that runs this sp on the first day of each quarter.
My question is, within the sp, if anything goes wrong, I do a rollback and
issue
a Return(5). Will this be interpeted as a failure within the job? Somehow I
think not.
So, how do I indicate failure to the job that schedules the sp?
Dan
Dan,
Add a RAISERROR statement to your stored procedure.
HTH
Jerry
"dan artuso" <dartuso@.NOSPAMpagepearls.com> wrote in message
news:OjXqmJfxFHA.2924@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I hope I can explain this well.
> I have an sp that populates certain tables with historical data and I've
> scheduled
> a job (using EM) that runs this sp on the first day of each quarter.
> My question is, within the sp, if anything goes wrong, I do a rollback and
> issue
> a Return(5). Will this be interpeted as a failure within the job? Somehow
> I think not.
> So, how do I indicate failure to the job that schedules the sp?
>
> Dan
>
>
|||Thanks Jerry
Dan
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:u7haHMfxFHA.1148@.TK2MSFTNGP11.phx.gbl...
> Dan,
> Add a RAISERROR statement to your stored procedure.
> HTH
> Jerry
> "dan artuso" <dartuso@.NOSPAMpagepearls.com> wrote in message
> news:OjXqmJfxFHA.2924@.TK2MSFTNGP15.phx.gbl...
>

Scheduling an sp

Hi All,
I hope I can explain this well.
I have an sp that populates certain tables with historical data and I've
scheduled
a job (using EM) that runs this sp on the first day of each quarter.
My question is, within the sp, if anything goes wrong, I do a rollback and
issue
a Return(5). Will this be interpeted as a failure within the job? Somehow I
think not.
So, how do I indicate failure to the job that schedules the sp?
DanDan,
Add a RAISERROR statement to your stored procedure.
HTH
Jerry
"dan artuso" <dartuso@.NOSPAMpagepearls.com> wrote in message
news:OjXqmJfxFHA.2924@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I hope I can explain this well.
> I have an sp that populates certain tables with historical data and I've
> scheduled
> a job (using EM) that runs this sp on the first day of each quarter.
> My question is, within the sp, if anything goes wrong, I do a rollback and
> issue
> a Return(5). Will this be interpeted as a failure within the job? Somehow
> I think not.
> So, how do I indicate failure to the job that schedules the sp?
>
> Dan
>
>|||Thanks Jerry
Dan
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:u7haHMfxFHA.1148@.TK2MSFTNGP11.phx.gbl...
> Dan,
> Add a RAISERROR statement to your stored procedure.
> HTH
> Jerry
> "dan artuso" <dartuso@.NOSPAMpagepearls.com> wrote in message
> news:OjXqmJfxFHA.2924@.TK2MSFTNGP15.phx.gbl...
>

Scheduling an sp

Hi All,
I hope I can explain this well.
I have an sp that populates certain tables with historical data and I've
scheduled
a job (using EM) that runs this sp on the first day of each quarter.
My question is, within the sp, if anything goes wrong, I do a rollback and
issue
a Return(5). Will this be interpeted as a failure within the job? Somehow I
think not.
So, how do I indicate failure to the job that schedules the sp?
DanDan,
Add a RAISERROR statement to your stored procedure.
HTH
Jerry
"dan artuso" <dartuso@.NOSPAMpagepearls.com> wrote in message
news:OjXqmJfxFHA.2924@.TK2MSFTNGP15.phx.gbl...
> Hi All,
> I hope I can explain this well.
> I have an sp that populates certain tables with historical data and I've
> scheduled
> a job (using EM) that runs this sp on the first day of each quarter.
> My question is, within the sp, if anything goes wrong, I do a rollback and
> issue
> a Return(5). Will this be interpeted as a failure within the job? Somehow
> I think not.
> So, how do I indicate failure to the job that schedules the sp?
>
> Dan
>
>|||Thanks Jerry
Dan
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:u7haHMfxFHA.1148@.TK2MSFTNGP11.phx.gbl...
> Dan,
> Add a RAISERROR statement to your stored procedure.
> HTH
> Jerry
> "dan artuso" <dartuso@.NOSPAMpagepearls.com> wrote in message
> news:OjXqmJfxFHA.2924@.TK2MSFTNGP15.phx.gbl...
>> Hi All,
>> I hope I can explain this well.
>> I have an sp that populates certain tables with historical data and I've
>> scheduled
>> a job (using EM) that runs this sp on the first day of each quarter.
>> My question is, within the sp, if anything goes wrong, I do a rollback
>> and issue
>> a Return(5). Will this be interpeted as a failure within the job? Somehow
>> I think not.
>> So, how do I indicate failure to the job that schedules the sp?
>>
>> Dan
>>
>sql

Scheduling a Report

Hello,
I am trying to create a schedule to add snapshots of a certain report to
report history.
So in Report Manager, I go to History and create a schedule to to this. In
my understanding, i need to create a job to execute this shedule. So i go to
Enterprise Manager to create a job. But after this i am lost, basically. How
can i reference this schedule when i go to "New Job". Is there any code that
needs to be put in the "New Job" Wizard so that this schedule can be run?
Thanks
SanjeevYou do not go to Enterprise Manager to do this. Do it all from within Report
Manager.
First create your schedule using Site Settings, Manage shared schedules. Do
this if you want to re-use the schedule with other reports.
Next, navigate to the report's folder and bring up its Properties window.
With the Properties window displayed, there is a History link on the left
side of the screen. Check the option to "Use the following schedule to add
snapshots to report history", then specify the schedule underneath.
HTH
Charles Kangai, MCT, MCDBA
"Sanjeev" wrote:
> Hello,
> I am trying to create a schedule to add snapshots of a certain report to
> report history.
> So in Report Manager, I go to History and create a schedule to to this. In
> my understanding, i need to create a job to execute this shedule. So i go to
> Enterprise Manager to create a job. But after this i am lost, basically. How
> can i reference this schedule when i go to "New Job". Is there any code that
> needs to be put in the "New Job" Wizard so that this schedule can be run?
> Thanks
> Sanjeev
>
>|||Thanks Charles. That worked
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:3D77E5E5-BAE9-484B-A87C-714EAD5350FC@.microsoft.com...
> You do not go to Enterprise Manager to do this. Do it all from within
> Report
> Manager.
> First create your schedule using Site Settings, Manage shared schedules.
> Do
> this if you want to re-use the schedule with other reports.
> Next, navigate to the report's folder and bring up its Properties window.
> With the Properties window displayed, there is a History link on the left
> side of the screen. Check the option to "Use the following schedule to add
> snapshots to report history", then specify the schedule underneath.
> HTH
> Charles Kangai, MCT, MCDBA
> "Sanjeev" wrote:
>> Hello,
>> I am trying to create a schedule to add snapshots of a certain report to
>> report history.
>> So in Report Manager, I go to History and create a schedule to to this.
>> In
>> my understanding, i need to create a job to execute this shedule. So i go
>> to
>> Enterprise Manager to create a job. But after this i am lost, basically.
>> How
>> can i reference this schedule when i go to "New Job". Is there any code
>> that
>> needs to be put in the "New Job" Wizard so that this schedule can be run?
>> Thanks
>> Sanjeev
>>

Scheduled weekly reports

I am trying to create a Job that will run a stored procedure i have scripted
and the email the the results to certain managers in my company for analysis
purposes. The procedure is fine i was just wondering how i would get the
results formatted and into an email. Do i use the SQL Mail?hi
did u see xp_sendmail
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---
"A.B." wrote:

> I am trying to create a Job that will run a stored procedure i have script
ed
> and the email the the results to certain managers in my company for analys
is
> purposes. The procedure is fine i was just wondering how i would get the
> results formatted and into an email. Do i use the SQL Mail?|||"A.B." <AB@.discussions.microsoft.com> wrote in message
news:4C34B83A-C86E-4031-ACEF-05B4F02B0326@.microsoft.com...
>I am trying to create a Job that will run a stored procedure i have
>scripted
> and the email the the results to certain managers in my company for
> analysis
> purposes. The procedure is fine i was just wondering how i would get the
> results formatted and into an email. Do i use the SQL Mail?
No, you use reporting services.|||Do both: use SQL Mail to send a message that the report is ready, but use SQ
L
Reporting Services for the actual report.
Why would you need to send a large amount of data through e-mail? Don't they
get enough spam anyway? ;)
ML|||"ML" <ML@.discussions.microsoft.com> wrote in message
news:7303024C-CB3B-4273-9D76-24D9C962D9BC@.microsoft.com...
> Do both: use SQL Mail to send a message that the report is ready, but use
> SQL
> Reporting Services for the actual report.
Or you could use Reporting Services to both render and send notification via
email.

schedule stored procedure

How to schedule a stored procedure to run at a certain system time in a regular basis?Use SQL Server Agent. You could configure SQL Server Agent jobs in Enterprise Manager or SQL Server Management Studio. Or by sp: sp_add_job, sp_add_jobstep, sp_add_jobschedule|||If you do not have SQL Agent available (you're using SQL 2005 Express), you can combine the use of SQLCmd.exe, Windows Scheduler, and Stored Procedures.

schedule

How is it possible to schedule a SSIS package to run at a certain time please?

First advice: USe the search functionality of the forum.

Second: you can use SQL SERVER AGENT that ships with SQL server 2005.

|||

Can not find anything regarding my question

Can you guide me through setting up a schedule of a ssis package or point me to a site that does just that please?

|||While going through the scheduling a task in SSMS, there does not seem to be an option to point to the ssis package on the network. How do I point to this package please?|||

Open your SQL Server 2005...

Goto to SQL Server Agent and add new JOB..

Go to the tab schedules!!

Helped?

Regards!!

|||Done that but do not see a browse functionality in there to point to the ssis package on the network.|||

Dear Friend,

Where is your SSIS package?!

regards!

|||

As I explained before, it is on the network.

Thanks

|||

Could you map the physical path to the package?!

Regards

|||

Hi,

I have explained all these in the previous posts.

Do you see an option to browse or place the path of the ssis packages because I don't.

|||

Yes...

You can browser your package to the file system!

Check the image I made for you in my blog:

http://pedrocgd.blogspot.com/2007/07/ssis-msdn-arkiboys-doubt.html

Helped?

Regards!

|||Ok, thanks|||

It's a pleasure!

regards!!