Job Schedule exceed more 3200 character

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Job Schedule exceed more 3200 character

Author

Topic

choyot
Starting Member

3 Posts

Posted - 2002-03-11 : 03:53:14

I run a job schedule which
drop and create back index key
But now i notice i can'nt put more than
3200 character. what should i do??
Should i create store procedure ?? How do i run store procedure from
scheduler..

Thank in advance

Nazim
A custom title

1408 Posts

Posted - 2002-03-11 : 08:09:01

yeah thts a good idea.

to execute a sp:

exec spname parameters

HTH

--------------------------------------------------------------

choyot
Starting Member

3 Posts

Posted - 2002-03-11 : 23:14:49

I write this step

create procedure dbindex() as

CREATE UNIQUE INDEX oas_addon1 ON dbo.oas_addon(appname, lstseqno) WITH FILLFACTOR = 90
GO

CREATE UNIQUE INDEX oas_addoncapab1 ON dbo.oas_addoncapab(capab, appname, code) WITH FILLFACTOR = 90
GO

CREATE UNIQUE INDEX oas_arcbalance_index1 ON dbo.oas_arcbalance(accode, yr, period, balcode, curcode, repbasis, cmpcode, curflag) WITH FILLFACTOR = 90
GO
..
..
but when i APPLY all statement missing before i can save..

why ??

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-11 : 23:52:26

You can't use GO inside a stored procedure. You can only use it at the end.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources