Will anyone plz help me in creating simple jobs in Sql Server. And how to run that Job. Actually i Created a job in the AGENT and schedule it daily at 2.30 pm . But it doesn't run automatically . . .
Thnx in Advance . .
Regards
(M. Nedu . . .)Hi,
The simple way to schedule a package is to right click on the package and you will get an option for scheduling. Once you are through it, you would find your package under "Jobs", check for the option which states "Enabled" and it should be "True". Try to run your Job manually and see whether it's executing fine. If it executes fine, then I am sure that it would execute on scheduled time.
Thanks & Regards
Mudasar
Quote:
Originally Posted by nedu
Hi Frndz,
Will anyone plz help me in creating simple jobs in Sql Server. And how to run that Job. Actually i Created a job in the AGENT and schedule it daily at 2.30 pm . But it doesn't run automatically . . .
Thnx in Advance . .
Regards
(M. Nedu . . .)
没有评论:
发表评论