The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
414 views

Problem sending an attachment using dbo.sp_send_dbmail

This question has been asked on the main stackexchange site I was referred here by a user there. ...
2
votes
1answer
85 views

Huge MSDB database

I have a very large MSDB database and have been working on clearing this out and setting up maintenance tasks - something my predecessor should have done years ago! So far I've managed to truncate ...
0
votes
1answer
49 views

Oprhaned entries in msdb..sysjobactivity

In this question: http://stackoverflow.com/questions/18445825/how-to-know-status-of-currently-running-jobs This answer was proposed: SELECT sj.name , sja.* FROM msdb.dbo.sysjobactivity AS sja ...
1
vote
0answers
94 views

Backup of msdb stuck in rollback

A native full backup of msdb on a SQL Server 2005 Enterprise instance (9.0.4053) deployed on a two-node Win2K3 cluster (Microsoft Windows NT 5.2 (3790)) is currently stuck in rollback. The DB is in ...
3
votes
1answer
649 views

How do I reclaim reserved space in the sysjobstepslogs table

I have a 36GB msdb database in my SQL Server 2008 R2 database server. From what I have read this is past the point of being gigantic. When I look at the tables in the msdb database the ...
1
vote
3answers
206 views

Getting the information that exists in “Job properties -> Notifications” page?

I use SQL Server 2008 R2 and I need get some properties from the msdb database. I need a query to get information that exists in the Job properties -> Notifications page. In which table I can ...
1
vote
1answer
57 views

who i can join msdb.dbo.sysalerts table with msdb.dbo.sysoperators table?

i use sql server 2008 r2. and i want create script of my jobs. i need find all object that exist in one job. To achieve this goal, i get all operators whit this query Select O.* From ...
2
votes
2answers
111 views

sysjobhistory “sql_severity” codes

Where can I find out what the different "sql_severity" codes mean in the sysjobhistory table? Eg what does 0 mean? I've inherited a report that excludes ones with a 0 as "0 is not a real error"? I ...
4
votes
1answer
1k views

Moving MSDB database

When I am trying to move msdb database from it's default location (C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA) to another drive(E:). After moving the database I am getting ...
0
votes
3answers
378 views

Fixing a query that returns failed job information

I' using a SQL Server 2008 Sp3 environment. I have a query that returns information about failed jobs from the last 10 minutes. If a job has two schedulers (for example - a job that runs every 10 ...
7
votes
1answer
142 views

Error in SSMS when attempting to restore a database

We have over a dozen SQL servers, one of which hosts a couple of hundred sage databases, when i right-click on the Databases node in SSMS there is a long delay then i get the following error (and the ...
4
votes
2answers
2k views

What would cause an orphaned ##MS_PolicyEventProcessingLogin##?

This morning I noticed my SQL Log was filling with the following message. The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'msdb.dbo.syspolicy_event_queue' output the ...