SQL Server Performance Forum – Threads Archive

How to Create and Schedule Jobs..

Hi Gurus, I need to Create and Schedule Jobs for certain Stored Procedure
to refresh the database. I have created a JOB using Enterprise Management.
But the Job never Ran.Why? My purpose is to create a job schedule it to execute
an Stored Procedure. Please Help.
Thanks, raj

---

Is sqlagent up?
Did you see any message in even viewer or sql log?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

check the last run date for the job.
Run the job manually and see whether there are any errors.
if there are no error schedule it from the scedule tab of the job

---

… additionally if the SQLAgent is already started then ensure the SQLAgent has required privileges to carryon the defined task. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Hi Satya, What are the required privileges of SQLAgent for Running the JOB
and Where do I assign them. Please help. Thanks raj

---

SQLAgent account could be system, or same that sqlserver start. You can change account in services.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

Findout the which account SQLagent using from Administrative tools –> services –> SQLAgent account.
BOL refers:
To reset SQLAgent permissions
Expand a server group, and then expand a server. Expand Management, right-click SQL Server Agent, and then click Properties. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

<br />When we have problems in scheduled job in SQL Server, these are the checklists to be reviewed.<br /><br />1)Check SQL Agent service is running<br />2)Confirm the job is enabled (Job properties, General Tab).<br />3)Check the concern schedule is enabled (Job properties, Schedules Tab).<br />4)Check ‘Last Run Status#%92, ‘Last run#%92 and ‘Next run#%92 columns in the scheduled jobs pane.<br />5) View the job history for any error occurred.<br />6)If possible manually launch the job and review what is happening.<br />7)When the job needs to access another instance or network resource then SQL Agent service account should have the sufficient permissions on the resource.<br /><br /><img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />Execute the stored procedure in Query Analyser and confirm it is executing without any error.<br />9)In the schedule job step, verify that you have chosen the correct database if it is a T-SQL task.<br /> <br />As per your posting, I assume the job is not a maintenance job or a logshipping job. They are having different set of checklist to troubleshoot them.<br /><br /><br />/* SKChandra */

---

Thanks All Got the Problem fixed. Thanks
raj

---

]]>