This link might help you.

http://msdn.microsoft.com/en-IN/library/ms187016.aspx

if nothing is there in execution job is doing nothing.

you can also script the job as other way to find the execution, by right click on job name and script...

?

you should have checked for previous logs as well. see if you find anything in eventviewer.

it can be tempdb full issue but not certain. also what is the tempdb recovery...

for mirroring there are certain perquisite in terms of environment, os and recovery so please go through it first.

second replication if your tables are having primary key in terms of...

everthing will be transferred, be it schema change or DML/DDL/DCL operation.

SQL Server allows only one Log Reader Agent per transactionally replicated database.

for security related you can go through below

http://msdn.microsoft.com/en-us/library/ms189405(v=sql.90).aspx

Also can you segregate now where the space is lying currently?

I mean for example out of 5 GB, how much by tables, how much by others, how much unused/unallocated...n...

if you have cleaned up and not released, have you truncated the log and shrink the database?

have you ran checkpoint manually??

Also find a good link on the same, refer below

http://www.mssqltips.com/sqlservertip/1461/analyze-and-correct-a-large-sql-server-msdb-database/

and

http://www.sqlservergeeks.com/sql-server-controlling-the-growth-of-msdb-database-caused-by-database-mail/

what is recovery mode for this system DB

Tune the query and check for missing indexes. fragmentation nothing to take with tempdb grow unexpectedly.

also check for other process setup you have in environment.

it depends on the size of DB as well.

if there is no issue with costing and other stuff go for failover clustering and other...

i guess information is limited thats why everyone is guessing.

can you please post the actual way you are running the query for view.

view structure is given, we want query which...

you can take ref help from those links,

http://social.msdn.microsoft.com/forums/sqlserver/en-US/0954880d-fecd-4e87-9d98-4ef6925f2667/scripting-sql-agent-jobs-with-powershell

http://www.dbascript.com/script-all-sql-agent-jobs-using-powershell