Good suggestion.

I am in the domain administrator group which I guess should take care of it.

It did not work with the domain id.

I did assign the job to 'sa' and...

Thanks skeane.

This kind of info is what I am looking for (sp_MSforeachdb). wow. I newer knew that.

I do not have control of the application since this is managed by the...

Thanks for the info.

My main issue is I am unable to switch between different databases due to the inherent requirement on looking at sysfiles for viewing the transaction log file...

Here is the complete script:

set nocount on

declare

       @v_dbname   nvarchar(128),

       @v_server   nvarchar(30),

       @sqlstring  nvarchar(1000),

       @sqlbkup    nvarchar(1000),

       @logfile    nvarchar(1000),

       @shrink_db  nvarchar(1000),

       @mytxnlog   nvarchar(1000)

select @v_server = @@servername

declare dbcursor cursor fast_forward for

select name...