-databasename, "-" should be "--" for comment

Declare @val varchar(250)

Set @val = 'New Stockcode : ' + Cast(getdate() as varchar)

@Subject = @val

I once Supported an Finance/Accounts System which used Triggers to alert agents when a sale had been made. One day the trigger to could send out any mails... The system...

Bad Idea..

So not send mail from a trigger.

Get the Trigger to write Whatever you want into some table.

Create a SQL Server Job to poll the said table every couple of...

Check the syspublications table in Published database.

select replicate_ddl from <Published_DB>.dbo.syspublications Where name = (Select name from sysarticles where name = 'Your Table Name')

If the value returned = 0, you have...

Do a Full backup 1x a week (say Saturday night). Then do Differential Backups Daily (if you must) and caryy on with the Log backups as normal.

So SQLAgent Account is sysadmin on SQL Server, and Local Admin on OS. Then Change the Job owner to "sa" and Try again.

Grant SQLAgent explicit permission to be able to login to the SQL Server. Place the SQLServerAgent Login in Admin Group on the local Server/Box.