The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
16 views

Unable to view SQL Server Agent while logged in as user

I apologize for asking with insufficient information. I have granted SQLAgentUserRole permission to one of the user in SQL server on msdb database, but when user login in to SSMS using his ...
1
vote
2answers
5k 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
42 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
281 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
753 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 ...