Can somone explain me how to run some procedure everyday at 22:00 in MSSQL.
This is not an Administrative Task, it's my procedure.
This is not an Administrative Task, it's my procedure.
-
-
Re: SQL + everyday
A scheduled Job would do it. You simply schedule your Proc to run.
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"pri10der" <pri10der@icpne t.pl> wrote in message
news:c5osnn$gsp $1@topaz.icpnet .pl...[color=blue]
> Can somone explain me how to run some procedure everyday at 22:00 in[/color]
MSSQL.[color=blue]
>
> This is not an Administrative Task, it's my procedure.
>
>
>
>
>[/color]
-
Re: SQL + everyday
[color=blue]
> A scheduled Job would do it. You simply schedule your Proc to run.[/color]
I tried but...
Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_add_jobsche dule'.
Is there any other posibility?
Comment
-
Re: SQL + everyday
Ok, now I understand why that was so easy for everyone,but not for me...
Thanks for help :)
Comment
Comment