Post reply

mssql newbie question concerning setting up Job Steps

  • April 28, 2004 at 2:50 pm

    #84183

    Hi,

    I'm an mssql beginner and have a question about creating Job Steps.

    Specifically, is there some limit as to the number of lines in the Command that can be pasted/edited in to the New Job Step Wiz window?

    If so, can it be overridden?

    Thanks,

    Burt

  • April 28, 2004 at 4:15 pm

    #504585

    I'm sure there is, but I'm not sure what it is? What type of step is this and how many lines? If it's T-SQL, perhaps you should create a stored procedure. Or a batch file for command executions.

     

  • April 28, 2004 at 4:25 pm

    #504587

    Hi,

    approximately 1K lines of sql - maybe 45 "paragraphs".

    The "script" builds many tables for subsequent use in an OLAP thing.

    I need to initiate it "off hours" - like at 3:00am.

    I guess I could break it down into 45 Job Steps, but that seems like a pain.

    Any suggestions would be most appreciated.

    Thanks,

    Burt

    p.s Jordan G. sez hey - turned me on to your site this morning

  • April 29, 2004 at 11:45 am

    #504725

    Take Steve's advice and put all of your table building code into a stored procedure or a batch file and execute it in one job step.

    Greg

     

    Greg

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply