SQL Server Agent

Changing the sql server service and agent windows account password

Hello, we are considering changing the sql server service and agent's password. What all should be considered prior to doing this? This will include doing this on 2000, 2005, and on clusters. Thanks!

SQL Server Agent Job Creation

Hello, My self Ashish Amodia from India, I want to send Automatic mail with an attachment for that I have created job and from job that I want to open my web page automatically - I am using SQL server 2000. If u know how to open web page from job than please let me know :) Thank you

Install sql server client tools

Client utilities like query browser, or query analyzer, how do I install on client workstations? I am not interested in installing a SQL server. I should just be able to query a SQL server and display some results from my laptop. Can anybody guide me? well, if we have to buy any licenses we will,...

SQL Server backup would not terminate

I tried to stop the backup which was already fired through job schedule,but it did't stop. Then I stop the sql serveragent but it also not abled to stop the backup. The backup size was 100GB. Could you please give me the reason and solution of it.

SQL Server 2005 log shipping network pass thru security

I have a need to ship logs to a remote secondary server that is in a different domain and without domain trusts. I have configured the SQL Agent on each machine to use a local account (.\SQLAgent) with the passwords the same on both machine. The secondary machine can read the network share that...

Job permissions in SQL Server Agent

Hi, I'm using SQL Server Agent which is running on SQL Server 2000. My question is, is there a way to give permissions to users to simply view the jobs and not change/execute them? I've read that this is possible in SQL 2005 with SQLAgentReaderRole, but what about 2000? Thanks in advance.

SQL Server Agent job Failures

I would like to know if there is any way to get Agent jobs such as backups, Update Stats jobs to write to the error log on failure. I have written a monitoring program that looks in the errorlog and alerts on pertinent errors. I would like to be able to use this solution for agent job failures...

Sql Server Agent

What causes an agent not to start? It appears in the services view as starting (instead of Started). WWhen it does start it, you try to do a job and it states that it cannot do so because the agent has not started.

Error message from SQL Server 2000 Agent after antivirus installation

SQL Server 2000 Agent would not start after the installation of the antivirus software Sophos and a reboot. I found the messaging service was shut off, so I started it, rebooted and the agent came up running. I then tried to start a backup job, but I received “error 14258,” which stated that...

Email notifications in SQL Server 2000 Enterprise Edition

In regards to email notifications in SQL Server 2000 Enterprise Edition, what level of authority does the SQL Server Agent account need in order to email me that a critical job has died?

how to Configure mail profile in MS SQL 2000 ?

I have a requirment to recieve mail from my SQL server 2000 when ever a JOB in my SQL SERVER Agent fails ,I have my MAPI configured and SMPT too but in the SQL SERVER AGENT Properties window , the Mail profile is not enabled , how do i configure this , I want it in SQL SERVER 2000.

How to Schedule jobs in DTS in sql server 2000

I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

How to set up a threshold on a SQL Server 2000 Agent backup job?

I would like advice on setting up a threshold if a SQL Server 2000 Agent backup job (nightly) is running after a certain time (7 a.m. PST), I would like to cancel it.