The error message that I get via Messenger Service is:

Status: Failed

MESSAGES: The job failed. The Job was invoked by user blah blah. The last step to run was step1 (script).

It just dies on that step. I can't find anything to indicate why.

Thanks again guys. Everything is working perfectly. I have over 100 databases running on a cluster that I wanted to do a differential backup on everynight and wanted to catch...

Thanks Gary and Brian, it's getting closer. That works to create the device. I just have to find out now why the looping thru the sysdatabases is busted.

I appreciate the help. This is alot more of pain than it should be.  Same unclosed quote error:

Here is the current code:

declare @IDENT INT, @sql varchar(1000), @DBNAME VARCHAR(200)

select...

Thanks. I tried that and got:

Server: Msg 170, Level 15, State 1, Line 20

Line 20: Incorrect syntax near ''.

Server: Msg 105, Level 15, State 1, Line 20

Unclosed quotation mark before...

Thanks all. With the leads that all the replys gave me I got it to work exacly as I need.

Jeff