Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MarkyBoy666
Starting Member
14 Posts |
 Posted - 2005-07-05 : 08:12:45
|
| I'm wanting to use the following piece of VBScript code as a DTS Job Step Command. The problem is, I'm getting an 'Invalid Character Error' which I've narrowed down to the '@' on the second line...yet this is copied and pasted (apart from job name) directly from MSDN! I really can't figure out why this is happening...does anyone know what I'm doing wrong? use msdb exec sp_update_job @job_name = 'TestJob', @enabled = 0 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-07-05 : 12:45:54
|
| it's t-sql not vbscript.If you put it in an execute sql task it should be ok.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS VBScript - strange error