scheduling stored procedure

how can i schedule a sp to run every 10 minutescreate an Agent Job with a single step that calls the sproc.|||thanks how do i do that in sql 2005

i'm using management studio|||Start by either reading Books Online or by right-clicking the Agent tab.

scheduling stored procedure

Hi,
I am trying to schedule a stored procedure using SQL server Agent and i get the following error:
DELETE failed because the following SET options have incorrect settings: 'ARITHABORT'. [SQLSTATE 42000]
please help
regards,
hirenI found this in SQL Books Online.

Is it appropriate, ie do you have computed columns etc ?

If SET ARITHABORT is OFF, CREATE, UPDATE, INSERT, and DELETE statements on tables with indexes on computed columns or indexed views will fail.|||Well what's it set to?

Do you have a trigger on the table?|||Hi,

No there are no triggers. I have found the solution.
The connection related setting for the SQL server needs to be checked for the same. I performed the following steps...
1. In enterprise manager, right clicked on SQL Server i was accessing.
2. Selected properties->Connections.
3. Under 'default connection option', selected 'Arithmetic abort'
4. Clicked OK and restarted the server.

Thanks and regards,
henry

Scheduling stored proc.

How do you schedule stored procedures? I can see no way of linking them to the job scheduler.
Also, how do I time the stored proc. schedule to activate after a scheduled DTS package?
Thanks again guys!OK, I see how to schedule a stored proc...by just scheduling an execute command.

But I still cant see how to time this with the scheduling of a DTS package.|||You create a new DTS.
You drop your connection,
You drop "Execute SQL TASK". You write your SQL-query

(example: "exec myproc")

you choose "save as" and name your DTS.
Now you will have a DTS in the list, and you right click on it and choose "Scedule Package"

Good luck!|||Its possible to execute and schedule a stored procedure using job scheduler just mention SP name and select connected database, schedule it.

scheduling ssis package

Hi there!!

I have created a ssis package and now i want to schedule it on SQL Server Agent.

How do we create new job for SSIS package?

Rahul Kumar

hi

gotta answer at:

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

thanks and regards

Rahul Kumar

sql

Scheduling SSIS Package

Hi ,

How do I schedule SSIS package.

Open Books Online. In the index type "packages", then look for scheduling under the Integration Services entry for packages in the index. The default topic "Scheduling Package Execution in SQL Server Agent" gives a good overview. The linked topic "How to: Run a Package Using a SQL Server Agent Job" gives a step by step description.

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 SQL Server 2005 report server

I'm looking a way to schedule a report to be generated in pre-define time and push it out to my users through email or file share any format (excell, Word, etc). Any help would be greatly appreciated.

When you view the report in a browser you'll see four tabs - View, Properties, History, Subscriptions. Create a new subscription and then enter the recipient (actual email address required) and select the Render Format as Excel, PDF, Web Archive etc. You can also set the date, time and frequency of the subscription.

Hope this helps,

Aidan

scheduling SQL Profiler

Hi all,
Is that possible to schedule a SQL Profiler session (without to keep a
windows session) ? If yes, how ?
Thank's.
Arnaud
You can use PSSDIAG utility to run profiler and it has scheduling capability
http://support.microsoft.com/default...b;en-us;830232
To learn how to use this tool
http://msdn.microsoft.com/library/de...v_12072004.asp
Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@.gmail.com
/* remove .online to send me e-mail */
Arnaud Demol wrote:
> Hi all,
> Is that possible to schedule a SQL Profiler session (without to keep a
> windows session) ? If yes, how ?
> Thank's.
> Arnaud
|||Arnaud Demol wrote:
> Hi all,
> Is that possible to schedule a SQL Profiler session (without to keep a
> windows session) ? If yes, how ?
> Thank's.
> Arnaud
You'll have to create a server-side trace to do this and avoid the
Profiler client. You can create the trace from Profiler and script it
out from the File Script Trace menu option. Once you have the trace
script, read about sp-trace_setstatus in BOL because you'll need to
learn how to stop a trace as well. You can then create a job in the SQL
Server Agent to execute the trace whenever you want. Stopping it is a
manual process since you'll need to know the trace handle in order to do
it. You could create a second job from the first one once you get the
handle for the trace.
You'll also need to make sure you set Profiler up to have the server
manage the trace and save the results to a file before you script out
the T-SQL.
You'll also need to look up sp_trace_gettable which allows you to read
trace files and optionally import them into a table in the database.
It will take some work to get it done, but once you understand the
process, you should have no trouble doing this on the regular basis.
David Gugick
Imceda Software
www.imceda.com
|||Sure...you can do that. They are called server side traces.
The specifics of how to run these depend upon what version
of SQL Server you are using.
With SQL Server 2000, You can start by using Profiler to
create a trace file which has your events, filters, etc.
that you want to trace. You will want to setup this trace to
be saved to a file. After you specify what you want to
trace, you can go up to the menu in Profiler to File and
select Script Trace to create a trace file definition. You
can then control and schedule the trace using the system
stored procedures that using the naming convention
sp_trace_xxxxx. You can find more information on these
stored procedures in books online. You can also find more
information in the following article:
http://support.microsoft.com/?id=822853
Towards the end of the article, there are links for
additional information.
If you are using SQL Server 7, the extended stored
procedures for controlling the traces are named
xp_trace_xxxxx.
Another difference between the two versions is that in SQL
Server 7, you can have server side traces saved directly to
a table (in 2000 you can't). But you would want to save to a
file anyway as it decreased the overhead for SQL Server.
-Sue
On Thu, 20 Jan 2005 04:15:02 -0800, Arnaud Demol <Arnaud
Demol@.discussions.microsoft.com> wrote:

>Hi all,
>Is that possible to schedule a SQL Profiler session (without to keep a
>windows session) ? If yes, how ?
>Thank's.
>Arnaud
sql

Scheduling SQL Agent job

Hello Everyone,

I wanted to schedule my SQL Agent Job with SSIS package loading data into Oracle Destination can it be possible, if not. What do i do to schedule my SSIS package?

Thank you

Yes, it is possible. See the following threads / technet articles on setting up a job / credentials / proxy etc.

http://support.microsoft.com/kb/912911

http://support.microsoft.com/?kbid=918760

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1322146&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703968&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2068280&SiteID=1

Scheduling sp_updatestats

Any reason NOT to use DTS to execute sp_updatestats on a daily basis?
Is there a better way to schedule that outside of a maintenance plan ?I prefer to use a SQL Agent Job. Using DTS isn't really necessary (and is
the wrong tool) in 'most' cases.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"J1C" <just1coder@.yahoo.ca> wrote in message
news:1164670349.026026.226980@.l39g2000cwd.googlegroups.com...
> Any reason NOT to use DTS to execute sp_updatestats on a daily basis?
> Is there a better way to schedule that outside of a maintenance plan ?
>|||Hello,
Why do you need DTS for this. All you have to do is:-
1. Open Enterprise Manager
2. Connect to SQL Server
3. Expand Management, Select Jobs and create new job.
4. In the job step give sp_updatestats and choose database
5. Provide a schedule to execute
6. Save the job
Based on the schedule.. SQL Server agent will trigger this job
Thanks
Hari
"J1C" <just1coder@.yahoo.ca> wrote in message
news:1164670349.026026.226980@.l39g2000cwd.googlegroups.com...
> Any reason NOT to use DTS to execute sp_updatestats on a daily basis?
> Is there a better way to schedule that outside of a maintenance plan ?
>|||Hari Prasad wrote:[vbcol=seagreen]
> Hello,
> Why do you need DTS for this. All you have to do is:-
> 1. Open Enterprise Manager
> 2. Connect to SQL Server
> 3. Expand Management, Select Jobs and create new job.
> 4. In the job step give sp_updatestats and choose database
> 5. Provide a schedule to execute
> 6. Save the job
> Based on the schedule.. SQL Server agent will trigger this job
> Thanks
> Hari
> "J1C" <just1coder@.yahoo.ca> wrote in message
> news:1164670349.026026.226980@.l39g2000cwd.googlegroups.com...
Thanks - that is what I ended up doing rather than DTS.

Scheduling sp_updatestats

Any reason NOT to use DTS to execute sp_updatestats on a daily basis?
Is there a better way to schedule that outside of a maintenance plan ?I prefer to use a SQL Agent Job. Using DTS isn't really necessary (and is
the wrong tool) in 'most' cases.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"J1C" <just1coder@.yahoo.ca> wrote in message
news:1164670349.026026.226980@.l39g2000cwd.googlegroups.com...
> Any reason NOT to use DTS to execute sp_updatestats on a daily basis?
> Is there a better way to schedule that outside of a maintenance plan ?
>|||Hello,
Why do you need DTS for this. All you have to do is:-
1. Open Enterprise Manager
2. Connect to SQL Server
3. Expand Management, Select Jobs and create new job.
4. In the job step give sp_updatestats and choose database
5. Provide a schedule to execute
6. Save the job
Based on the schedule.. SQL Server agent will trigger this job
Thanks
Hari
"J1C" <just1coder@.yahoo.ca> wrote in message
news:1164670349.026026.226980@.l39g2000cwd.googlegroups.com...
> Any reason NOT to use DTS to execute sp_updatestats on a daily basis?
> Is there a better way to schedule that outside of a maintenance plan ?
>|||Hari Prasad wrote:
> Hello,
> Why do you need DTS for this. All you have to do is:-
> 1. Open Enterprise Manager
> 2. Connect to SQL Server
> 3. Expand Management, Select Jobs and create new job.
> 4. In the job step give sp_updatestats and choose database
> 5. Provide a schedule to execute
> 6. Save the job
> Based on the schedule.. SQL Server agent will trigger this job
> Thanks
> Hari
> "J1C" <just1coder@.yahoo.ca> wrote in message
> news:1164670349.026026.226980@.l39g2000cwd.googlegroups.com...
> > Any reason NOT to use DTS to execute sp_updatestats on a daily basis?
> > Is there a better way to schedule that outside of a maintenance plan ?
> >
Thanks - that is what I ended up doing rather than DTS.

Scheduling sp_updatestats

Any reason NOT to use DTS to execute sp_updatestats on a daily basis?
Is there a better way to schedule that outside of a maintenance plan ?
I prefer to use a SQL Agent Job. Using DTS isn't really necessary (and is
the wrong tool) in 'most' cases.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"J1C" <just1coder@.yahoo.ca> wrote in message
news:1164670349.026026.226980@.l39g2000cwd.googlegr oups.com...
> Any reason NOT to use DTS to execute sp_updatestats on a daily basis?
> Is there a better way to schedule that outside of a maintenance plan ?
>
|||Hello,
Why do you need DTS for this. All you have to do is:-
1. Open Enterprise Manager
2. Connect to SQL Server
3. Expand Management, Select Jobs and create new job.
4. In the job step give sp_updatestats and choose database
5. Provide a schedule to execute
6. Save the job
Based on the schedule.. SQL Server agent will trigger this job
Thanks
Hari
"J1C" <just1coder@.yahoo.ca> wrote in message
news:1164670349.026026.226980@.l39g2000cwd.googlegr oups.com...
> Any reason NOT to use DTS to execute sp_updatestats on a daily basis?
> Is there a better way to schedule that outside of a maintenance plan ?
>
|||Hari Prasad wrote:[vbcol=seagreen]
> Hello,
> Why do you need DTS for this. All you have to do is:-
> 1. Open Enterprise Manager
> 2. Connect to SQL Server
> 3. Expand Management, Select Jobs and create new job.
> 4. In the job step give sp_updatestats and choose database
> 5. Provide a schedule to execute
> 6. Save the job
> Based on the schedule.. SQL Server agent will trigger this job
> Thanks
> Hari
> "J1C" <just1coder@.yahoo.ca> wrote in message
> news:1164670349.026026.226980@.l39g2000cwd.googlegr oups.com...
Thanks - that is what I ended up doing rather than DTS.

scheduling sms through sql server

hai to every one,

pls,help me "How to schedule Short message service to mobile phone using SQL server".Need help as soon as possible..........

See this related post...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1541109&SiteID=1

Short answer:

You can use Database Mail to send an email to your carrier's SMS gateway. If you want to schedule this, you can use SQL Server Agent.

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

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 reports to run

Is there a way to schedule reports to run on a specif day and time and save them to excel files?

Hello John,

Yes, of course you can.

Open Report Manager. (http://ServerName/Reports) and drill down to your report you want to schedule. Click on the Properties tab from the tob and the Data Sources tab from the left. Verify that you connection is correct and select 'Credentials stored securely in the report server' and give it an account to run the report. Then go to the Subscriptions tab from the top and hit 'New Subscription'. If you want to save to Excel, then select 'Report Server File Share' and set your options. Down at the bottom, you can set the schedule of the report.

Hope this helps.

Jarret

|||Thanks, Jarret. That's easy enough.sql

scheduling reports to refresh

Hi all!
Is it possible to schedule reports to refresh overnight? Particularly if
they take a long time to return data - for example in business objects i
would normally schedule a report to refresh overnight via the broadcast
agent console...is the same thing at all possible in reporting services?
does RS have sheduling functionality?
many thanks
GregYes, it has extensive functionality in this area.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:5E5D3B2C-AE87-4ABB-8E84-469A51511863@.microsoft.com...
> Hi all!
> Is it possible to schedule reports to refresh overnight? Particularly if
> they take a long time to return data - for example in business objects i
> would normally schedule a report to refresh overnight via the broadcast
> agent console...is the same thing at all possible in reporting services?
> does RS have sheduling functionality?
> many thanks
> Greg|||ok.....anything further? lol
HOW DO I DO IT!!!
anyone'
"Bruce L-C [MVP]" wrote:
> Yes, it has extensive functionality in this area.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Greg" <Greg@.discussions.microsoft.com> wrote in message
> news:5E5D3B2C-AE87-4ABB-8E84-469A51511863@.microsoft.com...
> > Hi all!
> >
> > Is it possible to schedule reports to refresh overnight? Particularly if
> > they take a long time to return data - for example in business objects i
> > would normally schedule a report to refresh overnight via the broadcast
> > agent console...is the same thing at all possible in reporting services?
> > does RS have sheduling functionality?
> >
> > many thanks
> >
> > Greg
>
>|||It seemed like you just wondered if it was possible. I thought that maybe
you weren't using Reporting Services and were just making plans.
Anyway, a few of what you need to understand. Search in books online for
snapshot, schedule and history. Reading up on those things should get you
started. Here are a few links to get you rolling:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsmain/htm/rsc_ov_using_v1_4u43.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_catalog_v1_9zsm.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_scheduling_v1_2qgk.asp
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:593EBCB8-9CA6-42BB-994C-CFAB8F44495F@.microsoft.com...
> ok.....anything further? lol
> HOW DO I DO IT!!!
> anyone'
> "Bruce L-C [MVP]" wrote:
>> Yes, it has extensive functionality in this area.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Greg" <Greg@.discussions.microsoft.com> wrote in message
>> news:5E5D3B2C-AE87-4ABB-8E84-469A51511863@.microsoft.com...
>> > Hi all!
>> >
>> > Is it possible to schedule reports to refresh overnight? Particularly
>> > if
>> > they take a long time to return data - for example in business objects
>> > i
>> > would normally schedule a report to refresh overnight via the
>> > broadcast
>> > agent console...is the same thing at all possible in reporting
>> > services?
>> > does RS have sheduling functionality?
>> >
>> > many thanks
>> >
>> > Greg
>>

Scheduling Report to render in to PDF format

Hi,
I have a report with 25 subreports which needs to generate one pdf file on
schedule basis (ie. schedule report to render in to PDF format based on some
time and date setting).
Is there any way of doing this?
Thanks in advance for the helper.
Regards.
AnithaYou need to subscribe to the report. As part of the subscription parameters
you can define the schedule of when you want the report to be automatically
generated.
Keep in mind that you have to also define a dafault value for each parameter
in your report.
Hope this helps,
Tigan
"Anitha Naidu" wrote:
> Hi,
> I have a report with 25 subreports which needs to generate one pdf file on
> schedule basis (ie. schedule report to render in to PDF format based on some
> time and date setting).
> Is there any way of doing this?
> Thanks in advance for the helper.
> Regards.
> Anitha
>

Scheduling Report Delivery to Printers

Hi,
Have any of you work with Extensions to schedule delivery of reports
directly to printers?
I played a little bit with the sample Delivery Extension provided by
Microsoft, I do not seem to get it to work.
Any ideas of how to schedule RS to print reports automatically?
ThanksThis is something I spent a lot of time on about a year ago without any
success.
The MS extensions I tried would almost work but it scaled the report just a
touch wrong and cut off text so it was of no use to me.
I would be very interested in solution myself.
"Jaraba" <Jaraba@.discussions.microsoft.com> wrote in message
news:E6E07910-4272-49C3-A3E9-86D6923B438B@.microsoft.com...
> Hi,
> Have any of you work with Extensions to schedule delivery of reports
> directly to printers?
> I played a little bit with the sample Delivery Extension provided by
> Microsoft, I do not seem to get it to work.
> Any ideas of how to schedule RS to print reports automatically?
> Thanks
>

Scheduling PSSDIAG

Hello,
I got this PSSDIAG from MS and i want to schedule that way i need not be the
on the machine or lock the machine.
Is there a way i can schedule this so that i start and stop the schedule so
that PSSDAIG starts and stops.
Any Help on this is appreciated.Use Windows Task scheduler, assuming its an exe file (I don't recall is
there is a way to schedule it within the tool itself).
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"chinn" <chinn@.discussions.microsoft.com> wrote in message
news:C8B3FEDD-078D-4D2D-AF53-9AE29AE5EED4@.microsoft.com...
> Hello,
> I got this PSSDIAG from MS and i want to schedule that way i need not be
> the
> on the machine or lock the machine.
> Is there a way i can schedule this so that i start and stop the schedule
> so
> that PSSDAIG starts and stops.
> Any Help on this is appreciated.
>

Scheduling PSSDIAG

Hello,
I got this PSSDIAG from MS and i want to schedule that way i need not be the
on the machine or lock the machine.
Is there a way i can schedule this so that i start and stop the schedule so
that PSSDAIG starts and stops.
Any Help on this is appreciated.Use Windows Task scheduler, assuming its an exe file (I don't recall is
there is a way to schedule it within the tool itself).
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"chinn" <chinn@.discussions.microsoft.com> wrote in message
news:C8B3FEDD-078D-4D2D-AF53-9AE29AE5EED4@.microsoft.com...
> Hello,
> I got this PSSDIAG from MS and i want to schedule that way i need not be
> the
> on the machine or lock the machine.
> Is there a way i can schedule this so that i start and stop the schedule
> so
> that PSSDAIG starts and stops.
> Any Help on this is appreciated.
>sql