The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
3k views

Add SSH host key to another user's PuTTY cache

I have written a PS1 script that 7-zips a file and uses PuTTY's SCP to store it at my back-up server. I have tested it and it works perfectly. Then I log into my SQL Server Agent and add an extra ...
3
votes
1answer
41 views

Can an Instance of SQL Server Express 2008 R2 be used as a Master Server?

For multi-server administration, can an instance of SQL Server Express 2008 R2 be used as a SQL Server Agent Master Server?
0
votes
4answers
230 views

Net send from Sql Server 2000 to Windows 7

I have a SQL Server Agent job that fails every once and a while. This has become a problem because I recently upgraded to windows 7, and so I no longer get the notifications for the failures. The ...
1
vote
1answer
576 views

SQL Agent History settings not being saved

I'm using Win 2K3 R2 + SP2 with SQL 2K8 R2 installed. I'm trying to set SQL Agent History to keep 1 week of logs. So here's what I do: After I connect, I right click SQL Server Agent and select ...
4
votes
2answers
2k views

Running “Rebuild Index” maintenance plan with “Online indexing”

I am using Windows Server 2003 SP 2 and SQL Server 2005 Enterprise edition I am creating a "Rebuild Index" job for a particular database and I am successfully able to run the job. But when I try to ...
3
votes
4answers
1k views

SQL Server Agent Job - Schedule daily except 1 day per month

We need to run a daily job using SQL Server Agent (SQL 2000) but we don't want it to run on the 22nd of each month as there are other processes which only run on that day which will clash. The ...