A better Windows Scheduler

I am looking for a scheduler to run batch jobs and vbscripts. I like
the SQLServerAgent Job scheduler but these jobs will not be running on
a SQL server.
The features I like in SQL are: history, email notifications and
advanced scheduling logic. Also, as a DBA, I've found SQLAgent to be
trustworthy - stable and reliable (unlike Windows Scheduler - which I
find pale in comparisson).
I'm aware that I could add this logic to the batches themselves, but
for the amount of files that will be scheduled daily - that's not a
practical solution.
Anyone thoughts? Thanks.I know CA do a scheduler but i think it will be overkill for your
requirements. Think it's called Unicentre
--
HTH
Ryan Waight, MCDBA, MCSE
"Sean O'Thule" <othule@.hotmail.com> wrote in message
news:63840202.0310060541.15fcf0e1@.posting.google.com...
> I am looking for a scheduler to run batch jobs and vbscripts. I like
> the SQLServerAgent Job scheduler but these jobs will not be running on
> a SQL server.
> The features I like in SQL are: history, email notifications and
> advanced scheduling logic. Also, as a DBA, I've found SQLAgent to be
> trustworthy - stable and reliable (unlike Windows Scheduler - which I
> find pale in comparisson).
> I'm aware that I could add this logic to the batches themselves, but
> for the amount of files that will be scheduled daily - that's not a
> practical solution.
> Anyone thoughts? Thanks.|||It may not meet you needs, but have you considered using DTS packages as the
container for managing the VB scripts, etc you need to run. You can then use
SQL Agent to actually manage the DTS packages.
You could easily run jobs that are not actually on the SQL Server... Not a
true general purpose scheduler, but it's free.
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Sean O'Thule" <othule@.hotmail.com> wrote in message
news:63840202.0310060541.15fcf0e1@.posting.google.com...
> I am looking for a scheduler to run batch jobs and vbscripts. I like
> the SQLServerAgent Job scheduler but these jobs will not be running on
> a SQL server.
> The features I like in SQL are: history, email notifications and
> advanced scheduling logic. Also, as a DBA, I've found SQLAgent to be
> trustworthy - stable and reliable (unlike Windows Scheduler - which I
> find pale in comparisson).
> I'm aware that I could add this logic to the batches themselves, but
> for the amount of files that will be scheduled daily - that's not a
> practical solution.
> Anyone thoughts? Thanks.|||I think you are referring to Autosys.
Linchi
>--Original Message--
>I know CA do a scheduler but i think it will be overkill
for your
>requirements. Think it's called Unicentre
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Sean O'Thule" <othule@.hotmail.com> wrote in message
>news:63840202.0310060541.15fcf0e1@.posting.google.com...
>> I am looking for a scheduler to run batch jobs and
vbscripts. I like
>> the SQLServerAgent Job scheduler but these jobs will
not be running on
>> a SQL server.
>> The features I like in SQL are: history, email
notifications and
>> advanced scheduling logic. Also, as a DBA, I've found
SQLAgent to be
>> trustworthy - stable and reliable (unlike Windows
Scheduler - which I
>> find pale in comparisson).
>> I'm aware that I could add this logic to the batches
themselves, but
>> for the amount of files that will be scheduled daily -
that's not a
>> practical solution.
>> Anyone thoughts? Thanks.
>
>.
>|||Looks expensive, I forgot to mention, I was hoping to find something
inexpensive or free.
I'm surprised MS doesn't take the componenets of the SQLAgent job
scheduler and generalize it for the OS. It's really a useful tool.
I want to avoid running everything from a SQL server. The first
server that I am looking to run this on will be an ftp server. Bits
of code will exist on that server itself (to encrypt/decrypt files).
So I prefer to run scripts locally.
Thanks for the input.