I have to write a JOB in sql server 2005 to be executed everyday 12AM. Please help me to create a JOB.
The easiest way would be to use SQL Server Agent to schedule your job to run every day at 12AM.
This link should point you in the right direction:
You need to make sure that the SQL Agent service is running on the machine. You can create a job in two ways, and the first leads to the second. Inside SMSS go into SQL Server Agent->Jobs->(right-click)->new jobs
from there you can give your job a name and create any steps from 'Steps' and set the time from 'Schedules'.
the second way to create a job is via script and if you create the job initially via SMSS you can script that job out to a file to see how it is created.
No one has followed this question yet.