Don't really understand what is your objective but may be you are looking for

select *

from msdb..sysmail_allitems

run

select * from msdb..sysjobactivity

check for next_scheduled_run_date.

You have to reschedule the job if the next_scheduled_run_date is off.

You can find you answer here.

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/27/unable-to-connect-to-a-sql-server-named-instance-on-a-cluster.aspx

Then use-

Convert(char(10),getdate(), 120) -- for date

Convert(char(8),getdate(),114)-- For time

Replace getdate(), with our column name.

Not sure about the question.But if it is datetime column, you can use

Covert(char(19),date, 120)

Do the agent which is configured to run snapshot agent have access (read/write permission)to snapshot folder?

If you are only worried about generating snapshot, which will affect both B & C, Use Server A as Publisher for both, and instead of initializing from snapshot, choose initialize...

Please check the below link..

http://stackoverflow.com/questions/2330439/access-is-denied-when-attaching-a-database

Are there any errors?

If this is scalar valued function, you have to give Grant Execute Permission on the function.

On TVF you have to give Grant Select.

In the Transitional Replication Schema Changes are propagated when Distribution agent runs.

You do not have to drop subscription.

Read through this.

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

You can ignore this error. This is not related to you job not running.

Can you try one thing drop and re-create your job and see if it starts running...

Index rebuild itself update stats so, you do not have to update stats after index rebuild.

here is one script from web. But if you google it you will find...

SQL Server Agent--> Error Logs.

What error you are getting?

Also even using DB_Owner role is not security best practice. I would suggest using db_datareader & db_datawriter

role. But if you post the error message that...