toooki
asked on
SQL server 2005 Create Scheduled Job
In SQL server 2005, I have two queries that I need to run as scheduled job with daily refresh.
These are the queries:
DELETE OPENQUERY ([MYLinkedServer], 'select * from Target_tab');
INSERT INTO OPENQUERY([MYLinkedServer] , 'select fid, FName from Target_tab')
select TNumber, FName from dbo.Source_tab;
The above queries run well on the SQL server 2005. The target is an Oracle database.
How do I create a scheduled job for these two queries on the SQL server?
These are the queries:
DELETE OPENQUERY ([MYLinkedServer], 'select * from Target_tab');
INSERT INTO OPENQUERY([MYLinkedServer]
select TNumber, FName from dbo.Source_tab;
The above queries run well on the SQL server 2005. The target is an Oracle database.
How do I create a scheduled job for these two queries on the SQL server?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL Server Agent is part of SQL Management Studio. If you don't see it you need to do some research on how to install it. It is what allows you to create scheduled jobs, backups, view event logs and so forth. If you aren't an administrator on the sql server then you need that person to give you permissions to create stored procedures. If you are an administrator but are logged in with a non admin account, you need to give that account permissions.
ASKER
Thank you. I am not the administrator of the database. I only have one login to use in that SQL server. And I am using SQL server management studio express.
I will ask the administrator to give me:
1. permissions to create stored procedures.
Do I need any other permission to create scheduled job?
I attached the screen-shot of the SQL server management studio (everything that shows under the database name). Was the the "SQL Server Agent" part supposed to show up here?
I will ask the administrator to give me:
1. permissions to create stored procedures.
Do I need any other permission to create scheduled job?
I attached the screen-shot of the SQL server management studio (everything that shows under the database name). Was the the "SQL Server Agent" part supposed to show up here?
I think you will have to also get permissions to create jobs. Here is a screen shot of what sql agent will look like if you had it.
SqlServerImage.docx
SqlServerImage.docx
ASKER
I found it later. I was using SQL server management studio "Express". The free one does not have the Agent. The licensed one has...
ASKER
I get error when I run the CREATE PROCEDURE command:
Msg 262, Level 14, State 1, Procedure MyProc1, Line 14
CREATE PROCEDURE permission denied in database 'myDbname'.
What privileges are needed to create PROCEDURE and create job?
Where do I find SQL server Agent? (I do not see under Programmability or Security tab)
Open in new window