Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Quotes within quotes in an Agent job question Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 6:33 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 12:42 PM
Points: 469, Visits: 2,358
Easy question, and just confirming what I think the answer is.

If I have some code I want in an Agent job, which has within it already double-quoted information, I don't need to double-double quote, correct?

Using the below code as an example:
exec sp_msforeachdb
'use [?];
Select whatever, convert(varchar(20),DatabasePropertyEX(''?'',''Status'')),
etc';
go

The proper formatting for this in an Agent job step would be:
'exec sp_msforeachdb
''use [?];
Select whatever, convert(varchar(20),DatabasePropertyEX(''?'',''Status'')),
etc''
go'

Yes?

Thanks all!
Jason A.
Post #1432604
Posted Tuesday, March 19, 2013 7:43 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 12:42 PM
Points: 469, Visits: 2,358
Never mind, I'm an id10t...

Forgot I don't need to wrap T-SQL in quotes in a T-SQL job step...
Post #1432646
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse