Scheduling Perfmon Recurring

Is there a way to schedule perfmon to run on a recurring schedule. I need it
to run during the business everyday for a week and currently will have to go
into the each server and set the schedule everyday. Is there a way to start
it remotely?
Thom
You can use the Logman utility that is available with XP or Win2K resource
kit. But why start and stop it each day? It does not take up that much
disk space. Are you running the gui or making a trace log? Open up perfmon
and expand the node in the treeview on the left where it says "Performance
Logs and Alerts". Then right click on the node that says "Counter Logs" and
choose "New Log settigs". Then give it a name and fill int he settings.
This will create a trace file that you can load back into perfmon later when
you want to read it or use the Logman utility to load the results into a
table. In either case there is a section for scheduling and you can tell it
to stop at the end of the week.
Andrew J. Kelly SQL MVP
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:37F072A2-BB39-4FA1-9F22-0B9E77CBC1EA@.microsoft.com...
> Is there a way to schedule perfmon to run on a recurring schedule. I need
> it
> to run during the business everyday for a week and currently will have to
> go
> into the each server and set the schedule everyday. Is there a way to
> start
> it remotely?
> Thom

Scheduling MSSQL Databases Daily Backup

Hi -
I want to Schedule Daily Backup of MSSQL Databases .. How can i do it .. How can i schedule it so that it get backuped everyday automatically at desired time.
Kind RegardsYou need to read up on Maintenance Plans on BOL. How yoyur databases are setup and each applications recovery requirements in order to setup the backups properly. Also read up on Recovery Plans.|||You can use the SQL Server Agent Utility (available through Enterprise Manager) to schedule jobs to run at regular times. The Maintenance Plan wizard merely creates the jobs for you (and also provides a convenient method of grouping databases upon which to perform identical maintenance).

blindman

Scheduling a task using DTS

Hey Guys!
I have a SQL Update Query that I want to run automatically everyday andI have read through the posts and I do not understand very clearly howto go about creating one.
The SQL query I want to run is this:
UPDATE Rental
SET TotalFee = ExtraFee + TotalFee
WHERE DaysOverdue >= 0
Once I have made a DTS package. How do I declare it in my coding?
Thanks in advance!
If you have access to add a job in SQL Agent, you can create a job and just run the query. You don't need DTS at all. If you don't have access to create a new job, then you'll have to do something outside of SQL using a different scheduling mechanism. Either way, there's no need for DTS to run a query like this. DTS is more for importing and/or exporting data and objects. Even if you did it in DTS, it's the SQL Agent service you'd use to create and schedule a job to run the DTS package.|||I never knew that there was another way of scheduling a SQL task.
I have tried to create a SQL Agent Task by going to Management >> SQL Server Agent >> Jobs
But for some reason it is not working even through I have scheduled a job so that it will run the query automatically.
I tested the SQL Agent Job by right clicking over my job and selecting 'Start Job'. Then an error occurs:
error 22022SQLServerAgent is not currently running so it cannot be notified forthis action
So how do i go about running it?
|||You have to start the Agent service. Once that's running, it will run the job on the schedule you define. Refer to Books on Line for more details on the Agent service.|||It works now!
Thanks!
sql

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

Scheduled transaction log backup never finish

Hi,
I run a scheduled transaction log job back up serval database's log
everyday, it was fine before, however, today, one of jobs seems can not stop
running. Checked no deadlock process, checked log file in disk, only two
database can not finish. using dbcc opentran, no active tran. change those
two database to another job, same thing happening, What could I do?
Any help would be appreciated.
Cheers
YifeiCancel the job using the Process Info under Current
Activity.
Have a look and see if there are any error messages being
generated in the SQL Server Logs, then try again.
Peter
"Never ascribe to malice, that which can be explained by
incompetence."
Napoleon
>--Original Message--
>Hi,
>I run a scheduled transaction log job back up serval
database's log
>everyday, it was fine before, however, today, one of jobs
seems can not stop
>running. Checked no deadlock process, checked log file in
disk, only two
>database can not finish. using dbcc opentran, no active
tran. change those
>two database to another job, same thing happening, What
could I do?
>Any help would be appreciated.
>Cheers
>Yifei
>
>.
>|||Hi Peter,
Thank you for reply, I do cancel the job and restart it again, the problem
still exist.
Actually I restart sql server, it's been fixed.
But, it looks strange.
Yifei
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:18a901c51b1f$feb702f0$a601280a@.phx.gbl...
> Cancel the job using the Process Info under Current
> Activity.
> Have a look and see if there are any error messages being
> generated in the SQL Server Logs, then try again.
> Peter
> "Never ascribe to malice, that which can be explained by
> incompetence."
> Napoleon
>
> >--Original Message--
> >Hi,
> >
> >I run a scheduled transaction log job back up serval
> database's log
> >everyday, it was fine before, however, today, one of jobs
> seems can not stop
> >running. Checked no deadlock process, checked log file in
> disk, only two
> >database can not finish. using dbcc opentran, no active
> tran. change those
> >two database to another job, same thing happening, What
> could I do?
> >
> >Any help would be appreciated.
> >
> >Cheers
> >
> >Yifei
> >
> >
> >
> >.
> >

Scheduled backup

I just loaded SQL 2000 sp3a on a Windows 2003 server and
copied a 7.0 database over from another server to test.
I scheduled a backup for everyday at 1:00 am and noticed
that it did not do it last night.
It looks like the SQL server agent is set up and waiting
to run but it didn't.
What am I missing?In EM, Management, Jobs ensure Enabled = Yes, Scheduled = Yes , Runnable =Yes
--
HTH
Ryan Waight, MCDBA, MCSE
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:11c001c3b435$12c0fdd0$a301280a@.phx.gbl...
> I just loaded SQL 2000 sp3a on a Windows 2003 server and
> copied a 7.0 database over from another server to test.
> I scheduled a backup for everyday at 1:00 am and noticed
> that it did not do it last night.
> It looks like the SQL server agent is set up and waiting
> to run but it didn't.
> What am I missing?
>|||Paul
A few ideas.
Most obvious, is SQL Agent running?
If it is have you checked the time on the server. If the
time is incorrect you may find your job kicking off any
time. Or have you changed the time on the server since
setting up the job. If you have re-create the job.
Have you looked in the Windows event log? If there are any
permissions problems you will see them there.
Hope this helps
John

schedule backup database

Hi All:
my local computer using sql server to maintain several databases
and i back up all database munallly everyday , so just wondering any idea i
can setup schedule job to backup database automatically everyday , for
exmaple back up database everyday at 5 pm.. etc
Cheers
nickCreate a database maintenance plan. It's simple, books online can show you
how.
Tip: Create two maintenance plans -- one for user databases and the other
for system databases (master, model, msdb). In the user DB plan, backup the
transaction logs. In the system DB plan, do not backup transaction logs.
John Steen
"Nick" wrote:
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>
>|||Watch a free flash video on creating database maintenance plans for
SQL Server.
http://www.eggheadcafe.com/videodemo/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:ufEG8xtDFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
> i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>

schedule backup database

Hi All:
my local computer using sql server to maintain several databases
and i back up all database munallly everyday , so just wondering any idea i
can setup schedule job to backup database automatically everyday , for
exmaple back up database everyday at 5 pm.. etc
Cheers
nick
Create a database maintenance plan. It's simple, books online can show you
how.
Tip: Create two maintenance plans -- one for user databases and the other
for system databases (master, model, msdb). In the user DB plan, backup the
transaction logs. In the system DB plan, do not backup transaction logs.
John Steen
"Nick" wrote:

> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>
>
|||Watch a free flash video on creating database maintenance plans for
SQL Server.
http://www.eggheadcafe.com/videodemo/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:ufEG8xtDFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
> i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>

schedule backup database

Hi All:
my local computer using sql server to maintain several databases
and i back up all database munallly everyday , so just wondering any idea i
can setup schedule job to backup database automatically everyday , for
exmaple back up database everyday at 5 pm.. etc
Cheers
nickCreate a database maintenance plan. It's simple, books online can show you
how.
Tip: Create two maintenance plans -- one for user databases and the other
for system databases (master, model, msdb). In the user DB plan, backup the
transaction logs. In the system DB plan, do not backup transaction logs.
John Steen
"Nick" wrote:

> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>
>|||Watch a free flash video on creating database maintenance plans for
SQL Server.
http://www.eggheadcafe.com/videodemo/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:ufEG8xtDFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
> i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>