Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Task Scheduling

5 posts in Windows NT Last posting was on 1998-05-14 13:31:39.0Z
Todd McGuire Posted on 1998-05-11 14:49:15.0Z
Message-ID: <35570FEB.41A2@softworkscc.com>
Date: Mon, 11 May 1998 10:49:15 -0400
From: Todd McGuire <todd@softworkscc.com>
Organization: SOFTWORKS
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Task Scheduling
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 4
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5027
Article PK: 1092391

Hi All,
Using SQL Server 11.0.2.
How can I schedule a task to run at a specific time each month?

Thanks,
Todd McGuire


Reinoud van Leeuwen Posted on 1998-05-12 12:48:09.0Z
Message-ID: <35584509.11E8@sybase.com>
Date: Tue, 12 May 1998 14:48:09 +0200
From: Reinoud van Leeuwen <reinoud@sybase.com>
Organization: Sybase Inc.
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
To: Todd McGuire <todd@softworkscc.com>
Subject: Re: Task Scheduling
References: <35570FEB.41A2@softworkscc.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 15
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5019
Article PK: 1092386


Todd McGuire wrote:
>
> Hi All,
> Using SQL Server 11.0.2.
> How can I schedule a task to run at a specific time each month?

The simple answer is: you can't...

The more difficult answer is: yes you can with a little trickery...
The NT scheduler can only schedule scripts on a weekday. You'll probably
have to write a job that checks wheter is is the first day in the month
and only does something when this is the case. (such a check would
probably be easier in SQL than in a batch file...)

Reinoud van Leeuwen
Sybase Professional Services Maarssen / The Netherlands


Steve Hittle Posted on 1998-05-11 16:03:02.0Z
Message-ID: <35572136.138@hsc.healthplan.com>
Date: Mon, 11 May 1998 12:03:02 -0400
From: Steve Hittle <SHittle@hsc.healthplan.com>
Organization: Harrington ISD
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
Subject: Re: Task Scheduling
References: <35570FEB.41A2@softworkscc.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 16
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5026
Article PK: 1092390


Todd McGuire wrote:
>
> Hi All,
> Using SQL Server 11.0.2.
> How can I schedule a task to run at a specific time each month?
>
> Thanks,
> Todd McGuire

Todd,

You have only one option installed with NT, and that is WinAt. This
is very basic scheduling utilility that just runs batch files. It
does not monitor each time they run nor does it tell you if
it errored, but its free.

The other option is to purchase a third party job scheduler that can
actually monitor the processes and track errors. There are many
of these available at varying costs.

Good Luck,

Steve


Todd McGuire Posted on 1998-05-12 18:20:13.0Z
Message-ID: <355892DD.6DB3@softworkscc.com>
Date: Tue, 12 May 1998 14:20:13 -0400
From: Todd McGuire <todd@softworkscc.com>
Organization: SOFTWORKS
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: Task Scheduling
References: <35570FEB.41A2@softworkscc.com> <35572136.138@hsc.healthplan.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 20
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5017
Article PK: 1092385


Steve Hittle wrote:
>
> Todd McGuire wrote:
> >
> > Hi All,
> > Using SQL Server 11.0.2.
> > How can I schedule a task to run at a specific time each month?
> >
> > Thanks,
> > Todd McGuire
>
> Todd,
>
> You have only one option installed with NT, and that is WinAt. This
> is very basic scheduling utilility that just runs batch files. It
> does not monitor each time they run nor does it tell you if
> it errored, but its free.
>
> The other option is to purchase a third party job scheduler that can
> actually monitor the processes and track errors. There are many
> of these available at varying costs.
>
> Good Luck,
>
> Steve

Hi Steve,
Thanks for the info... What is WinAT? How do I get it installed?

Thanks,
Todd


Steve Hittle Posted on 1998-05-14 13:31:39.0Z
Message-ID: <355AF23B.4D11@hsc.healthplan.com>
Date: Thu, 14 May 1998 09:31:39 -0400
From: Steve Hittle <SHittle@hsc.healthplan.com>
Organization: Harrington ISD
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
Subject: Re: Task Scheduling
References: <35570FEB.41A2@softworkscc.com> <35572136.138@hsc.healthplan.com> <355892DD.6DB3@softworkscc.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 34
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5012
Article PK: 1092376


Todd McGuire wrote:
>
> Steve Hittle wrote:
> >
> > Todd McGuire wrote:
> > >
> > > Hi All,
> > > Using SQL Server 11.0.2.
> > > How can I schedule a task to run at a specific time each month?
> > >
> > > Thanks,
> > > Todd McGuire
> >
> > Todd,
> >
> > You have only one option installed with NT, and that is WinAt. This
> > is very basic scheduling utilility that just runs batch files. It
> > does not monitor each time they run nor does it tell you if
> > it errored, but its free.
> >
> > The other option is to purchase a third party job scheduler that can
> > actually monitor the processes and track errors. There are many
> > of these available at varying costs.
> >
> > Good Luck,
> >
> > Steve
> Hi Steve,
> Thanks for the info... What is WinAT? How do I get it installed?
>
> Thanks,
> Todd

I believe it comes with the NT 4.0 resource kit. It may not be
called WinAT, but Command Scheduler. It is very basic, but does
allow you run jobs either daily, weekly, day of week, or just one
time. Once it kicks off a .bat job, it does nothing. No error
checking or even verification if the job name actually exists. I
have used it though to automate the backups (both nightly dumps
and hourly transaction dumps) as well as dbccs, re-indexing, etc.

Hope this helps.

Steve