running after hours

[EscapeUK]

I have 2 SQL statements that need running at around mid night. Can Enterprise manager do this for me. If not how could I go about completing this task.

if you have any idea could you give me some examples. Also I am new to this so could you keep the exaples simple.

Thanks

 

[jnicho02]

Enterprise Manager includes a task scheduler that enables you to run script files or a line of sql. The line of sql could be a call to a stored procedure, so you can run a lot more than a single line of code.

Any script file that you run will be run by the server itself (or more accurately, the NT account that you have specified for the SQLAgent), and you can specify which user account it uses. The SQLAgent needs to be running - check with the traffic light startup program.

I can't give an example as I don't have SQL Server here (at work)....Maybe someone else can oblige. My home ---->

http://www.geocities.com/jnicho02/

My company ->

http://www.firstlightassociates.co.uk/

 

[EscapeUK]

Thanks

However how can I display all the secheduled jobs. I can only seem to be able to create new ones

 

[EscapeUK]

Sorry found it, under management SQLServer Agent