You created a job to run two SQL statements every day at 1:00pm. When you checked your job (Jobs view in Teratrax Database Manager) the next day, you noticed that it says “Failed” under “Last Run Status”.
Run the following SQL command (copy command and paste it in the SQL window in Teratrax Database Manager or Teratrax Source Guard) to determine the cause of failure. It returns the job history of the specified job (replace job name with the name of your job):
EXECUTE MSDB.DBO.SP_HELP_JOBHISTORY NULL,
'job name', @MODE = N'SEM'
Result:
| step_id | step_name | message | run_status | etc… |
|---|---|---|---|---|
| 0 | (Job outcome) | The job failed. The… | 0 | etc… |
| 1 | Step1 | Executed as user… | 0 | etc… |
The message cell contains the error messages that were recorded at the time the job ran. If the job was successful, the cell will still indicate the success status.
Beekeeper Studio Adalah GUI Database Gratis & Open Source
Alat query SQL & editor terbaik yang pernah saya gunakan. Menyediakan semua yang saya butuhkan untuk mengelola database saya. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio cepat, intuitif, dan mudah digunakan. Beekeeper mendukung banyak database dan berfungsi dengan baik di Windows, Mac, dan Linux.
Apa Kata Pengguna Tentang Beekeeper Studio
"Beekeeper Studio sepenuhnya menggantikan alur kerja SQL lama saya. Cepat, intuitif, dan membuat pekerjaan database menyenangkan lagi."
"Saya sudah mencoba banyak GUI database, tapi Beekeeper menemukan keseimbangan sempurna antara fitur dan kesederhanaan. Langsung berfungsi."