September 29, 2003 at 7:55 am
I want to run a regular daily job using System Monitor, how do you do it? I can run a real-time job; I can schedule a one-off job to run at any time in the future. How can I schedule this job to run daily between say 10.00 and 12:00? I am running SQL Server 2000 against Windows 2000. I am also struggling to understand how to save a file with the counter information in order to call this file at a later date. When you define your counter log and give it a name, is this the file I should be calling manually and what suffix does it have? I am getting confused as in NT4 you would save a file as .pmc, whereas in win2k when you save your setting it saves it as an htm file!
Can anyone please explain in layman’s terms the intricacies of System Monitor?
Edited by - campbellm on 09/29/2003 08:29:22 AM
October 2, 2003 at 8:00 am
This was removed by the editor as SPAM
October 2, 2003 at 8:22 am
Go to performance monitor --> Right click counter logs --> New Log setting --> Add counters you want to log --> Schedule Tab --> configure to run at your timeframe.
To save a monitoring console
Open Performance. Using System Monitor or a tool under Performance Logs and Alerts, configure the tool with the settings you want. On the Console menu, click Save As, and then type the name you want for this console. The default directory for storing this file is System32 on the root volume. click Save.
October 2, 2003 at 8:50 am
Thanks for the response but it doesn't address my problem. I want to log the information on a daily basis between 10:00 and 12:00. The response only tells me how to schedule a one off job which I already Know about. I don't want to have to log on to the machine every day and set up a scheduled job to run that day. I want to set up a job and schedule it to run every day. Not asking for much, am I ? The .msc file that you save when run does not log the data.
October 2, 2003 at 9:08 am
quote:
I want to set up a job and schedule it to run every day
Check 'Satrt a new log file' will make system to create another log file at time you specified.
quote:
The .msc file that you save when run does not log the data.
It gives you only the counters you defined. In order to get data, you need to log the counters into log file.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply