Hi There,

How can i use go on multiline statement, I would like to create job step
which contains go in it. But i can not create. I try to use something like
this

EXEC sp_add_jobstep
    @job_name = N'Audit_Log Truncate',
    @step_name = N'AG Audit Log Truncate',
    @subsystem = N'TSQL',
    @command =
N'
use adminsys_SIPP_AIG
Go
if exists (select * from sysobjects where name = ''audit_log'')
truncate table audit_log
Go

use master
<Go>
DBCC SHRINKDATABASE  (adminsys_SIPP_AIG)

use adminsys_SIPP_AIG
BACKUP LOG adminsys_SIPP_AIG with no_log
DBCC SHRINKFILE  (ADMINSYS_SIPP_AIG_log,10)
',
    @retry_attempts = 5,
    @on_success_action = 3,
    @on_fail_action = 3,
    @retry_interval = 5 ;
GO

Thanks in advance

Ganesh (gsgan***@yahoo.com) writes:
Show quoteHide quoteThat certainly looks like a syntax error to me. Syntactially GO is just an
identifier as far as SQL Server is concerned. It could be the name of a
table, stored procedure etc. GO as a batch separator is only something
that is used by query tools. (So if you were to run this from, say, Query
Analyzer, you would get an error immediately, because QA would cut the
batch before the string terminates.)

You can define for a job step which database it is to run in. And there
is no need to switch to master to shrink the database.

But even better: don't shrink the database at all. It's reasonable to
shrink a database if you archived a lot of data that never will reappear,
or if there has been some excessive operation. But it's a bad idea to
shrink it, if will grow again. Autogrow is not cheap, and creates load
on the system.

Absolutely agree.

For more info, Ganesh, see
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

stop using dynamic sql
how to write extended stored procedure to generate sequences.
dll & Web Service in VB.Net 2005 Stored Procedure
Sorting a parent-child list
UDT, what's the point?