I have a report that has to be delivered via email on the last day of each
month. I am using a last_day function to capture the last day of each month.
Can I store this in a table and have RS2000 email based on the value in the
table? If so, how?
Thanks in advance
OSIs there any way you can upgrade to SQL 2005? The reporting services is SO
MUCH BETTER... and you can EASILY create a report subscription that will send
on the last day of the month.
--
~lb
"OriginalStealth" wrote:
> I have a report that has to be delivered via email on the last day of each
> month. I am using a last_day function to capture the last day of each month.
> Can I store this in a table and have RS2000 email based on the value in the
> table? If so, how?
> Thanks in advance
> OS
Showing posts with label via. Show all posts
Showing posts with label via. Show all posts
Wednesday, March 28, 2012
Scheduling DTS packages in SQLServer 2005 via the Run Time utility
All,
I installed SQLServer 2005 on a new box and installed the DTS Runtime
utility as well so that the DTS packages run in the 2005 environment.
I imported all the DTS packages but I dont know how to schedule each of
them. Would anyone know. In SQLServer 2000, "Schedule Package" menu on a DTS
package would create and schedule a job. I'm not sure how to do it here other
than creating the job manually.
Thanks,
rgnCreate an Agent job with a CmdExec jobstep. In this jobstep, you execute DTSRUN.EXE with appropriate
command-line options (see 2000 Books Online for documentation of the command-line options for
DTSRUN.EXE).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"rgn" <rgn@.discussions.microsoft.com> wrote in message
news:5B08D6C7-9A39-49AF-8EA5-532627D5E310@.microsoft.com...
> All,
> I installed SQLServer 2005 on a new box and installed the DTS Runtime
> utility as well so that the DTS packages run in the 2005 environment.
> I imported all the DTS packages but I dont know how to schedule each of
> them. Would anyone know. In SQLServer 2000, "Schedule Package" menu on a DTS
> package would create and schedule a job. I'm not sure how to do it here other
> than creating the job manually.
> Thanks,
> rgn
>|||rgn,
Apparently, since DTS is being deprecated the scheduling function did not
move over with the legacy support.
However, creating your own job is pretty easy, especially if you examine the
job definitions created for you on your SQL Server 2000 server. In fact, you
may be able to simply script out the jobs from SQL Server 2000 and run those
scripts on your 2005 SQL Server.
Some adjustements may be necessary. For example, if the same logins used
for the jobs on 2000 do not exist on your new 2005 server, you will need to
adjust the scripts to point to the logins you wish to use.
RLF
"rgn" <rgn@.discussions.microsoft.com> wrote in message
news:5B08D6C7-9A39-49AF-8EA5-532627D5E310@.microsoft.com...
> All,
> I installed SQLServer 2005 on a new box and installed the DTS Runtime
> utility as well so that the DTS packages run in the 2005 environment.
> I imported all the DTS packages but I dont know how to schedule each of
> them. Would anyone know. In SQLServer 2000, "Schedule Package" menu on a
> DTS
> package would create and schedule a job. I'm not sure how to do it here
> other
> than creating the job manually.
> Thanks,
> rgn
>|||Tibor/Russell,
I should have been clearer in my earlier post. I can create a job for each
one of the DTS packages with DTSRUN. However, I dont know how to generate the
encrypted details of the package name, login name, Password ... etc.
It is against our SOX policy to include password in open text.
THis example is for a different DTS on a different server altogether.[DTSRun
/~Z0xBBA31CD08C42214454A70882A4D929948FA0915B8AA465A7BEF16CCA4AC7639EB256D85DB6780227228D2D92A3FF92D1AAC3354C13AF4CCF5704F24B8EA95C5C95E33BE0EAF73A5ED7C9F1D9AA391B364F64B7473F9E27823B3EF142CE09CF1F1BF7E08A031026BC2F7E03E544C824E13C2584B3C7197F19A12371 ]
Thanks,
rgn
"Russell Fields" wrote:
> rgn,
> Apparently, since DTS is being deprecated the scheduling function did not
> move over with the legacy support.
> However, creating your own job is pretty easy, especially if you examine the
> job definitions created for you on your SQL Server 2000 server. In fact, you
> may be able to simply script out the jobs from SQL Server 2000 and run those
> scripts on your 2005 SQL Server.
> Some adjustements may be necessary. For example, if the same logins used
> for the jobs on 2000 do not exist on your new 2005 server, you will need to
> adjust the scripts to point to the logins you wish to use.
> RLF
>
> "rgn" <rgn@.discussions.microsoft.com> wrote in message
> news:5B08D6C7-9A39-49AF-8EA5-532627D5E310@.microsoft.com...
> > All,
> >
> > I installed SQLServer 2005 on a new box and installed the DTS Runtime
> > utility as well so that the DTS packages run in the 2005 environment.
> >
> > I imported all the DTS packages but I dont know how to schedule each of
> > them. Would anyone know. In SQLServer 2000, "Schedule Package" menu on a
> > DTS
> > package would create and schedule a job. I'm not sure how to do it here
> > other
> > than creating the job manually.
> >
> > Thanks,
> > rgn
> >
> >
>
>|||rgn,
I poked around a bit and found that the encrypted details are not as secure
as you might wish. So... user beware. Here is how you can generate one:
dtsrun /S ServerName /E /N PackagePathAndName /!Y
You will see that it gives a different encryption each time, but try it out
and see if the results work for you.
Since you are in SQL Server 2005, I encourage you to study up on SQL Agent
Proxies, which use Credentials for Logins to switch execution context before
running the Operating System step of DTSRUN. If that works for you, you can
run your DTS Packages without any user names or passwords in the command
line. Much more secure.
RLF
"rgn" <rgn@.discussions.microsoft.com> wrote in message
news:C777E793-E904-4D38-A361-E642C056AF7A@.microsoft.com...
> Tibor/Russell,
> I should have been clearer in my earlier post. I can create a job for each
> one of the DTS packages with DTSRUN. However, I dont know how to generate
> the
> encrypted details of the package name, login name, Password ... etc.
> It is against our SOX policy to include password in open text.
> THis example is for a different DTS on a different server
> altogether.[DTSRun
> /~Z0xBBA31CD08C42214454A70882A4D929948FA0915B8AA465A7BEF16CCA4AC7639EB256D85DB6780227228D2D92A3FF92D1AAC3354C13AF4CCF5704F24B8EA95C5C95E33BE0EAF73A5ED7C9F1D9AA391B364F64B7473F9E27823B3EF142CE09CF1F1BF7E08A031026BC2F7E03E544C824E13C2584B3C7197F19A12371
> ]
> Thanks,
> rgn
> "Russell Fields" wrote:
>> rgn,
>> Apparently, since DTS is being deprecated the scheduling function did not
>> move over with the legacy support.
>> However, creating your own job is pretty easy, especially if you examine
>> the
>> job definitions created for you on your SQL Server 2000 server. In fact,
>> you
>> may be able to simply script out the jobs from SQL Server 2000 and run
>> those
>> scripts on your 2005 SQL Server.
>> Some adjustements may be necessary. For example, if the same logins used
>> for the jobs on 2000 do not exist on your new 2005 server, you will need
>> to
>> adjust the scripts to point to the logins you wish to use.
>> RLF
>>
>> "rgn" <rgn@.discussions.microsoft.com> wrote in message
>> news:5B08D6C7-9A39-49AF-8EA5-532627D5E310@.microsoft.com...
>> > All,
>> >
>> > I installed SQLServer 2005 on a new box and installed the DTS Runtime
>> > utility as well so that the DTS packages run in the 2005 environment.
>> >
>> > I imported all the DTS packages but I dont know how to schedule each of
>> > them. Would anyone know. In SQLServer 2000, "Schedule Package" menu on
>> > a
>> > DTS
>> > package would create and schedule a job. I'm not sure how to do it here
>> > other
>> > than creating the job manually.
>> >
>> > Thanks,
>> > rgn
>> >
>> >
>>sql
I installed SQLServer 2005 on a new box and installed the DTS Runtime
utility as well so that the DTS packages run in the 2005 environment.
I imported all the DTS packages but I dont know how to schedule each of
them. Would anyone know. In SQLServer 2000, "Schedule Package" menu on a DTS
package would create and schedule a job. I'm not sure how to do it here other
than creating the job manually.
Thanks,
rgnCreate an Agent job with a CmdExec jobstep. In this jobstep, you execute DTSRUN.EXE with appropriate
command-line options (see 2000 Books Online for documentation of the command-line options for
DTSRUN.EXE).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"rgn" <rgn@.discussions.microsoft.com> wrote in message
news:5B08D6C7-9A39-49AF-8EA5-532627D5E310@.microsoft.com...
> All,
> I installed SQLServer 2005 on a new box and installed the DTS Runtime
> utility as well so that the DTS packages run in the 2005 environment.
> I imported all the DTS packages but I dont know how to schedule each of
> them. Would anyone know. In SQLServer 2000, "Schedule Package" menu on a DTS
> package would create and schedule a job. I'm not sure how to do it here other
> than creating the job manually.
> Thanks,
> rgn
>|||rgn,
Apparently, since DTS is being deprecated the scheduling function did not
move over with the legacy support.
However, creating your own job is pretty easy, especially if you examine the
job definitions created for you on your SQL Server 2000 server. In fact, you
may be able to simply script out the jobs from SQL Server 2000 and run those
scripts on your 2005 SQL Server.
Some adjustements may be necessary. For example, if the same logins used
for the jobs on 2000 do not exist on your new 2005 server, you will need to
adjust the scripts to point to the logins you wish to use.
RLF
"rgn" <rgn@.discussions.microsoft.com> wrote in message
news:5B08D6C7-9A39-49AF-8EA5-532627D5E310@.microsoft.com...
> All,
> I installed SQLServer 2005 on a new box and installed the DTS Runtime
> utility as well so that the DTS packages run in the 2005 environment.
> I imported all the DTS packages but I dont know how to schedule each of
> them. Would anyone know. In SQLServer 2000, "Schedule Package" menu on a
> DTS
> package would create and schedule a job. I'm not sure how to do it here
> other
> than creating the job manually.
> Thanks,
> rgn
>|||Tibor/Russell,
I should have been clearer in my earlier post. I can create a job for each
one of the DTS packages with DTSRUN. However, I dont know how to generate the
encrypted details of the package name, login name, Password ... etc.
It is against our SOX policy to include password in open text.
THis example is for a different DTS on a different server altogether.[DTSRun
/~Z0xBBA31CD08C42214454A70882A4D929948FA0915B8AA465A7BEF16CCA4AC7639EB256D85DB6780227228D2D92A3FF92D1AAC3354C13AF4CCF5704F24B8EA95C5C95E33BE0EAF73A5ED7C9F1D9AA391B364F64B7473F9E27823B3EF142CE09CF1F1BF7E08A031026BC2F7E03E544C824E13C2584B3C7197F19A12371 ]
Thanks,
rgn
"Russell Fields" wrote:
> rgn,
> Apparently, since DTS is being deprecated the scheduling function did not
> move over with the legacy support.
> However, creating your own job is pretty easy, especially if you examine the
> job definitions created for you on your SQL Server 2000 server. In fact, you
> may be able to simply script out the jobs from SQL Server 2000 and run those
> scripts on your 2005 SQL Server.
> Some adjustements may be necessary. For example, if the same logins used
> for the jobs on 2000 do not exist on your new 2005 server, you will need to
> adjust the scripts to point to the logins you wish to use.
> RLF
>
> "rgn" <rgn@.discussions.microsoft.com> wrote in message
> news:5B08D6C7-9A39-49AF-8EA5-532627D5E310@.microsoft.com...
> > All,
> >
> > I installed SQLServer 2005 on a new box and installed the DTS Runtime
> > utility as well so that the DTS packages run in the 2005 environment.
> >
> > I imported all the DTS packages but I dont know how to schedule each of
> > them. Would anyone know. In SQLServer 2000, "Schedule Package" menu on a
> > DTS
> > package would create and schedule a job. I'm not sure how to do it here
> > other
> > than creating the job manually.
> >
> > Thanks,
> > rgn
> >
> >
>
>|||rgn,
I poked around a bit and found that the encrypted details are not as secure
as you might wish. So... user beware. Here is how you can generate one:
dtsrun /S ServerName /E /N PackagePathAndName /!Y
You will see that it gives a different encryption each time, but try it out
and see if the results work for you.
Since you are in SQL Server 2005, I encourage you to study up on SQL Agent
Proxies, which use Credentials for Logins to switch execution context before
running the Operating System step of DTSRUN. If that works for you, you can
run your DTS Packages without any user names or passwords in the command
line. Much more secure.
RLF
"rgn" <rgn@.discussions.microsoft.com> wrote in message
news:C777E793-E904-4D38-A361-E642C056AF7A@.microsoft.com...
> Tibor/Russell,
> I should have been clearer in my earlier post. I can create a job for each
> one of the DTS packages with DTSRUN. However, I dont know how to generate
> the
> encrypted details of the package name, login name, Password ... etc.
> It is against our SOX policy to include password in open text.
> THis example is for a different DTS on a different server
> altogether.[DTSRun
> /~Z0xBBA31CD08C42214454A70882A4D929948FA0915B8AA465A7BEF16CCA4AC7639EB256D85DB6780227228D2D92A3FF92D1AAC3354C13AF4CCF5704F24B8EA95C5C95E33BE0EAF73A5ED7C9F1D9AA391B364F64B7473F9E27823B3EF142CE09CF1F1BF7E08A031026BC2F7E03E544C824E13C2584B3C7197F19A12371
> ]
> Thanks,
> rgn
> "Russell Fields" wrote:
>> rgn,
>> Apparently, since DTS is being deprecated the scheduling function did not
>> move over with the legacy support.
>> However, creating your own job is pretty easy, especially if you examine
>> the
>> job definitions created for you on your SQL Server 2000 server. In fact,
>> you
>> may be able to simply script out the jobs from SQL Server 2000 and run
>> those
>> scripts on your 2005 SQL Server.
>> Some adjustements may be necessary. For example, if the same logins used
>> for the jobs on 2000 do not exist on your new 2005 server, you will need
>> to
>> adjust the scripts to point to the logins you wish to use.
>> RLF
>>
>> "rgn" <rgn@.discussions.microsoft.com> wrote in message
>> news:5B08D6C7-9A39-49AF-8EA5-532627D5E310@.microsoft.com...
>> > All,
>> >
>> > I installed SQLServer 2005 on a new box and installed the DTS Runtime
>> > utility as well so that the DTS packages run in the 2005 environment.
>> >
>> > I imported all the DTS packages but I dont know how to schedule each of
>> > them. Would anyone know. In SQLServer 2000, "Schedule Package" menu on
>> > a
>> > DTS
>> > package would create and schedule a job. I'm not sure how to do it here
>> > other
>> > than creating the job manually.
>> >
>> > Thanks,
>> > rgn
>> >
>> >
>>sql
Friday, March 23, 2012
Scheduled task alerts in 6.5
Is it possible to setup SQL server 6.5 to automatically inform me via email
when a scheduled task fails? Im told that this is possible in 2000, but not
in 6.5.
Is there any work around? some scripts or a 3rd party util ?
olly
________________________________________________
Macinley.co.uk
http://www.macinley.co.uk
Hi,
Yes, You can do an Email alert in SQL 6.5
1. Enterprise manager -- Select Server menu -- choose Alerts / Operators
2. Click in the Operator tab -- New OPerator -- Mention a operator ID and
give the email address
3. CLick OK
4. Go to ALerts tab -- CReate new alert
5. Mention and id and in the respose definition select the "Scheduled Task
to fire"
6. Mention the Alert Notification message and click ok
So when ever there is a error raised an Email alert will be send.
Thanks
Hari
MCDBA
"Harry Hudini" <harry.hudini@.nospam@.simplicity.co.uk> wrote in message
news:#dzjybIcEHA.3016@.tk2msftngp13.phx.gbl...
> Is it possible to setup SQL server 6.5 to automatically inform me via
email
> when a scheduled task fails? Im told that this is possible in 2000, but
not
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
> --
> ________________________________________________
> Macinley.co.uk
> http://www.macinley.co.uk
>
|||Harry,
As a side note, you should be aware that SQL Server 6.5 is no longer
supported by Microsoft. I do not recommend you use it in production (or
anywhere else). Upgrade to SQL Server 2000 as soon as you can.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Harry Hudini wrote:
> Is it possible to setup SQL server 6.5 to automatically inform me via email
> when a scheduled task fails? Im told that this is possible in 2000, but not
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
>
when a scheduled task fails? Im told that this is possible in 2000, but not
in 6.5.
Is there any work around? some scripts or a 3rd party util ?
olly
________________________________________________
Macinley.co.uk
http://www.macinley.co.uk
Hi,
Yes, You can do an Email alert in SQL 6.5
1. Enterprise manager -- Select Server menu -- choose Alerts / Operators
2. Click in the Operator tab -- New OPerator -- Mention a operator ID and
give the email address
3. CLick OK
4. Go to ALerts tab -- CReate new alert
5. Mention and id and in the respose definition select the "Scheduled Task
to fire"
6. Mention the Alert Notification message and click ok
So when ever there is a error raised an Email alert will be send.
Thanks
Hari
MCDBA
"Harry Hudini" <harry.hudini@.nospam@.simplicity.co.uk> wrote in message
news:#dzjybIcEHA.3016@.tk2msftngp13.phx.gbl...
> Is it possible to setup SQL server 6.5 to automatically inform me via
> when a scheduled task fails? Im told that this is possible in 2000, but
not
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
> --
> ________________________________________________
> Macinley.co.uk
> http://www.macinley.co.uk
>
|||Harry,
As a side note, you should be aware that SQL Server 6.5 is no longer
supported by Microsoft. I do not recommend you use it in production (or
anywhere else). Upgrade to SQL Server 2000 as soon as you can.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Harry Hudini wrote:
> Is it possible to setup SQL server 6.5 to automatically inform me via email
> when a scheduled task fails? Im told that this is possible in 2000, but not
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
>
Scheduled task alerts in 6.5
Is it possible to setup SQL server 6.5 to automatically inform me via email
when a scheduled task fails? Im told that this is possible in 2000, but not
in 6.5.
Is there any work around? some scripts or a 3rd party util ?
olly
________________________________________
________
Macinley.co.uk
http://www.macinley.co.ukHi,
Yes, You can do an Email alert in SQL 6.5
1. Enterprise manager -- Select Server menu -- choose Alerts / Operators
2. Click in the Operator tab -- New OPerator -- Mention a operator ID and
give the email address
3. CLick OK
4. Go to ALerts tab -- CReate new alert
5. Mention and id and in the respose definition select the "Scheduled Task
to fire"
6. Mention the Alert Notification message and click ok
So when ever there is a error raised an Email alert will be send.
Thanks
Hari
MCDBA
"Harry Hudini" <harry.hudini@.nospam@.simplicity.co.uk> wrote in message
news:#dzjybIcEHA.3016@.tk2msftngp13.phx.gbl...
> Is it possible to setup SQL server 6.5 to automatically inform me via
email
> when a scheduled task fails? Im told that this is possible in 2000, but
not
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
> --
> ________________________________________
________
> Macinley.co.uk
> http://www.macinley.co.uk
>|||Harry,
As a side note, you should be aware that SQL Server 6.5 is no longer
supported by Microsoft. I do not recommend you use it in production (or
anywhere else). Upgrade to SQL Server 2000 as soon as you can.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Harry Hudini wrote:
> Is it possible to setup SQL server 6.5 to automatically inform me via emai
l
> when a scheduled task fails? Im told that this is possible in 2000, but no
t
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
>sql
when a scheduled task fails? Im told that this is possible in 2000, but not
in 6.5.
Is there any work around? some scripts or a 3rd party util ?
olly
________________________________________
________
Macinley.co.uk
http://www.macinley.co.ukHi,
Yes, You can do an Email alert in SQL 6.5
1. Enterprise manager -- Select Server menu -- choose Alerts / Operators
2. Click in the Operator tab -- New OPerator -- Mention a operator ID and
give the email address
3. CLick OK
4. Go to ALerts tab -- CReate new alert
5. Mention and id and in the respose definition select the "Scheduled Task
to fire"
6. Mention the Alert Notification message and click ok
So when ever there is a error raised an Email alert will be send.
Thanks
Hari
MCDBA
"Harry Hudini" <harry.hudini@.nospam@.simplicity.co.uk> wrote in message
news:#dzjybIcEHA.3016@.tk2msftngp13.phx.gbl...
> Is it possible to setup SQL server 6.5 to automatically inform me via
> when a scheduled task fails? Im told that this is possible in 2000, but
not
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
> --
> ________________________________________
________
> Macinley.co.uk
> http://www.macinley.co.uk
>|||Harry,
As a side note, you should be aware that SQL Server 6.5 is no longer
supported by Microsoft. I do not recommend you use it in production (or
anywhere else). Upgrade to SQL Server 2000 as soon as you can.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Harry Hudini wrote:
> Is it possible to setup SQL server 6.5 to automatically inform me via emai
l
> when a scheduled task fails? Im told that this is possible in 2000, but no
t
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
>sql
Scheduled task alerts in 6.5
Is it possible to setup SQL server 6.5 to automatically inform me via email
when a scheduled task fails? Im told that this is possible in 2000, but not
in 6.5.
Is there any work around? some scripts or a 3rd party util ?
olly
--
________________________________________________
Macinley.co.uk
http://www.macinley.co.ukHi,
Yes, You can do an Email alert in SQL 6.5
1. Enterprise manager -- Select Server menu -- choose Alerts / Operators
2. Click in the Operator tab -- New OPerator -- Mention a operator ID and
give the email address
3. CLick OK
4. Go to ALerts tab -- CReate new alert
5. Mention and id and in the respose definition select the "Scheduled Task
to fire"
6. Mention the Alert Notification message and click ok
So when ever there is a error raised an Email alert will be send.
Thanks
Hari
MCDBA
"Harry Hudini" <harry.hudini@.nospam@.simplicity.co.uk> wrote in message
news:#dzjybIcEHA.3016@.tk2msftngp13.phx.gbl...
> Is it possible to setup SQL server 6.5 to automatically inform me via
email
> when a scheduled task fails? Im told that this is possible in 2000, but
not
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
> --
> ________________________________________________
> Macinley.co.uk
> http://www.macinley.co.uk
>|||Harry,
As a side note, you should be aware that SQL Server 6.5 is no longer
supported by Microsoft. I do not recommend you use it in production (or
anywhere else). Upgrade to SQL Server 2000 as soon as you can.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Harry Hudini wrote:
> Is it possible to setup SQL server 6.5 to automatically inform me via email
> when a scheduled task fails? Im told that this is possible in 2000, but not
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
>
when a scheduled task fails? Im told that this is possible in 2000, but not
in 6.5.
Is there any work around? some scripts or a 3rd party util ?
olly
--
________________________________________________
Macinley.co.uk
http://www.macinley.co.ukHi,
Yes, You can do an Email alert in SQL 6.5
1. Enterprise manager -- Select Server menu -- choose Alerts / Operators
2. Click in the Operator tab -- New OPerator -- Mention a operator ID and
give the email address
3. CLick OK
4. Go to ALerts tab -- CReate new alert
5. Mention and id and in the respose definition select the "Scheduled Task
to fire"
6. Mention the Alert Notification message and click ok
So when ever there is a error raised an Email alert will be send.
Thanks
Hari
MCDBA
"Harry Hudini" <harry.hudini@.nospam@.simplicity.co.uk> wrote in message
news:#dzjybIcEHA.3016@.tk2msftngp13.phx.gbl...
> Is it possible to setup SQL server 6.5 to automatically inform me via
> when a scheduled task fails? Im told that this is possible in 2000, but
not
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
> --
> ________________________________________________
> Macinley.co.uk
> http://www.macinley.co.uk
>|||Harry,
As a side note, you should be aware that SQL Server 6.5 is no longer
supported by Microsoft. I do not recommend you use it in production (or
anywhere else). Upgrade to SQL Server 2000 as soon as you can.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Harry Hudini wrote:
> Is it possible to setup SQL server 6.5 to automatically inform me via email
> when a scheduled task fails? Im told that this is possible in 2000, but not
> in 6.5.
> Is there any work around? some scripts or a 3rd party util ?
> olly
>
Tuesday, March 20, 2012
Scheduled Jobs
Its not possible to schedule jobs via Express is it? Like I have a process that connects to an Oracle system grabs the data... plays with it some and then inserts it into the MSSQL 2005 server... We need this process to run say every 2 hours... Express cant do that cant it?SQL Express has no SQL Agent job scheduling service. You can execute the appropiate jobs using SQLCMD and the AT or any other scheduling service on your machine.
See the feature comparison here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||hi,
in addition to Jens answer, you can perhaps have a look at "third party" solutions, both commercial and free, like http://www.valesoftware.com/products-express-agent.php and http://www.codeproject.com/useritems/SQLAgent.asp to implement scheduled features..
regards
|||another possible solution (thats free) is to create a small batch script that calls sqlcmd and does your sql processing. this batch file could then be scheduled using windows scheduling to be called every 2 hours.Friday, March 9, 2012
Scheduled Backups
I have setup several backup sets via the individual database.
But - in SQL Server 2000 - my brain has faded away. I can't find where to
access those scheduled backups that I setup?
Can anyone help me find where to change scheduled backup times? I am sure
it's right in front of my face, and I am just missing it.
Thanks
Kevin
Hi,
1. Open SQl Server Enterprise manager
2. Expand the server you need to change the backup job timings
3. Go to "Management" Option
4. Expand " SQL Server Agent"
5. Select "Jobs"
6. Now in the right side of window pane all the jobs will be displayed.
7. Double click on ur job , select the schedules , click EDIT and change the
timings
8. Click OK and APPLY.
Thanks
Hari
MCDBA
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
|||Hi,
1. Open SQl Server Enterprise manager
2. Expand the server you need to change the backup job timings
3. Go to "Management" Option
4. Expand " SQL Server Agent"
5. Select "Jobs"
6. Now in the right side of window pane all the jobs will be displayed.
7. Double click on ur job , select the schedules , click EDIT and change the
timings
8. Click OK and APPLY.
Thanks
Hari
MCDBA
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
|||Using Enterprise Manager
your server > Management > SQL Server Agent > Jobs
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
|||Using Enterprise Manager
your server > Management > SQL Server Agent > Jobs
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
But - in SQL Server 2000 - my brain has faded away. I can't find where to
access those scheduled backups that I setup?
Can anyone help me find where to change scheduled backup times? I am sure
it's right in front of my face, and I am just missing it.
Thanks
Kevin
Hi,
1. Open SQl Server Enterprise manager
2. Expand the server you need to change the backup job timings
3. Go to "Management" Option
4. Expand " SQL Server Agent"
5. Select "Jobs"
6. Now in the right side of window pane all the jobs will be displayed.
7. Double click on ur job , select the schedules , click EDIT and change the
timings
8. Click OK and APPLY.
Thanks
Hari
MCDBA
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
|||Hi,
1. Open SQl Server Enterprise manager
2. Expand the server you need to change the backup job timings
3. Go to "Management" Option
4. Expand " SQL Server Agent"
5. Select "Jobs"
6. Now in the right side of window pane all the jobs will be displayed.
7. Double click on ur job , select the schedules , click EDIT and change the
timings
8. Click OK and APPLY.
Thanks
Hari
MCDBA
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
|||Using Enterprise Manager
your server > Management > SQL Server Agent > Jobs
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
|||Using Enterprise Manager
your server > Management > SQL Server Agent > Jobs
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
Scheduled Backups
I have setup several backup sets via the individual database.
But - in SQL Server 2000 - my brain has faded away. I can't find where to
access those scheduled backups that I setup?
Can anyone help me find where to change scheduled backup times? I am sure
it's right in front of my face, and I am just missing it.
Thanks
KevinHi,
1. Open SQl Server Enterprise manager
2. Expand the server you need to change the backup job timings
3. Go to "Management" Option
4. Expand " SQL Server Agent"
5. Select "Jobs"
6. Now in the right side of window pane all the jobs will be displayed.
7. Double click on ur job , select the schedules , click EDIT and change the
timings
8. Click OK and APPLY.
Thanks
Hari
MCDBA
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>|||Using Enterprise Manager
your server > Management > SQL Server Agent > Jobs
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
But - in SQL Server 2000 - my brain has faded away. I can't find where to
access those scheduled backups that I setup?
Can anyone help me find where to change scheduled backup times? I am sure
it's right in front of my face, and I am just missing it.
Thanks
KevinHi,
1. Open SQl Server Enterprise manager
2. Expand the server you need to change the backup job timings
3. Go to "Management" Option
4. Expand " SQL Server Agent"
5. Select "Jobs"
6. Now in the right side of window pane all the jobs will be displayed.
7. Double click on ur job , select the schedules , click EDIT and change the
timings
8. Click OK and APPLY.
Thanks
Hari
MCDBA
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>|||Using Enterprise Manager
your server > Management > SQL Server Agent > Jobs
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
Scheduled Backups
I have setup several backup sets via the individual database.
But - in SQL Server 2000 - my brain has faded away. I can't find where to
access those scheduled backups that I setup?
Can anyone help me find where to change scheduled backup times? I am sure
it's right in front of my face, and I am just missing it.
Thanks
KevinHi,
1. Open SQl Server Enterprise manager
2. Expand the server you need to change the backup job timings
3. Go to "Management" Option
4. Expand " SQL Server Agent"
5. Select "Jobs"
6. Now in the right side of window pane all the jobs will be displayed.
7. Double click on ur job , select the schedules , click EDIT and change the
timings
8. Click OK and APPLY.
Thanks
Hari
MCDBA
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>|||Using Enterprise Manager
your server > Management > SQL Server Agent > Jobs
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
But - in SQL Server 2000 - my brain has faded away. I can't find where to
access those scheduled backups that I setup?
Can anyone help me find where to change scheduled backup times? I am sure
it's right in front of my face, and I am just missing it.
Thanks
KevinHi,
1. Open SQl Server Enterprise manager
2. Expand the server you need to change the backup job timings
3. Go to "Management" Option
4. Expand " SQL Server Agent"
5. Select "Jobs"
6. Now in the right side of window pane all the jobs will be displayed.
7. Double click on ur job , select the schedules , click EDIT and change the
timings
8. Click OK and APPLY.
Thanks
Hari
MCDBA
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>|||Using Enterprise Manager
your server > Management > SQL Server Agent > Jobs
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
Subscribe to:
Posts (Atom)